LOG(X), LOG(B,X): If called with one parameter, this function returns the natural logarithm of X : LOG « Math Numeric Functions « MySQL Tutorial






mysql>
mysql> SELECT LOG(2);
+------------------+
| LOG(2)           |
+------------------+
| 0.69314718055995 |
+------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT LOG(-2);
+---------+
| LOG(-2) |
+---------+
|    NULL |
+---------+
1 row in set (0.00 sec)

mysql>








21.21.LOG
21.21.1.LOG(X), LOG(B,X): If called with one parameter, this function returns the natural logarithm of X
21.21.2.Using LOG with data in a table