Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the logarithm of the given argument to base 10.
LOG10 ( number )
LOG10(n) is equivalent to LOG(n) / LOG(10).
Float or double. If number is less than or equal to 0, or if base is non-positive or 1, returns NULL.
SELECT LOG10(1000);
+-------------+
| LOG10(1000) |
+-------------+
| 3 |
+-------------+