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