LOG, LOG10: Get logarithm of a number

LOG(number) : Natural logarithm of a number

LOG10(number) : Log base 10 of a number

mysql> SELECT LOG(10);
+-------------------+
| LOG(10)           |
+-------------------+
| 2.302585092994046 |
+-------------------+
1 row in set (0.01 sec)

mysql> SELECT LOG10(10);
+-----------+
| LOG10(10) |
+-----------+
|         1 |
+-----------+
1 row in set (0.00 sec)

Previous                                                 Next                                                 Home