log10

description

Syntax

DOUBLE log10(DOUBLE x) Returns the natural logarithm of x to base 10.

example

1. mysql> select log10(1);
2. +------------+
3. | log10(1.0) |
4. +------------+
5. |          0 |
6. +------------+
7. mysql> select log10(10);
8. +-------------+
9. | log10(10.0) |
10. +-------------+
11. |           1 |
12. +-------------+
13. mysql> select log10(16);
14. +--------------------+
15. | log10(16.0)        |
16. +--------------------+
17. | 1.2041199826559248 |
18. +--------------------+

keywords

1. LOG10