LOG
Returns the logarithm of the given argument in the given base. If only one argument is given, this function returns the “natural” logarithm to base e.
Syntax
LOG ( base, number ) LOG ( number )
Arguments
base: the base of the logarithm.
number: the number to take the logarithm of.
Notice
LOG(n) is an alias for LN(n).
LOG(b, n) is equivalent to LN(n) / LN(b). {{% /callout %}}
Return Type
Float or double. If number is less than or equal to 0, or if base is non-positive or 1, returns NULL.
Examples
SELECT LOG(2, 16); +------------+ | LOG(2, 16) | +------------+ | 4 | +------------+ SELECT LOG(2, 1234); +-------------------+ | LOG(2, 1234) | +-------------------+ | 10.26912667914942 | +-------------------+ SELECT LOG(1234); +--------------------+ | LOG(1234) | +--------------------+ | 7.1180162044653335 | +--------------------+ SELECT LN(1234); +--------------------+ | LN(1234) | +--------------------+ | 7.1180162044653335 | +--------------------+ SELECT LOG(10, 1000), LN(1000) / LN(10); +--------------------+--------------------+ | LOG(10, 1000) | LN(1000) / LN(10) | +--------------------+--------------------+ | 2.9999999999999996 | 2.9999999999999996 | +--------------------+--------------------+ SELECT LOG(-9); +---------+ | LOG(-9) | +---------+ | NULL | +---------+