LOG10

LOG10(X)

Devuelve el logaritmo en base 10 de X:

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

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

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