LOG10
Returns the logarithm of the given argument to base 10.
Syntax
LOG10 ( number )
Arguments
number: the number to take the logarithm of.
Note
LOG10(n) is equivalent to LOG(n) / LOG(10).
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 LOG10(1000); **** +-------------+ | LOG10(1000) | +-------------+ | 3 | +-------------+