Name

LOG( )

Synopsis

LOG(number[, base])

This function returns the natural logarithm of a given number. If a second argument is given, a natural logarithm is returned for the first argument for the arbitrary base given in the second argument. This is the same as using LOG(number)/LOG(base).

SELECT LOG(5,4);
+------------+
|   LOG(5,4) |
+------------+
| 1.16096405 |
+------------+

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.