log

description

Syntax

DOUBLE log(DOUBLE b, DOUBLE x) Returns the logarithm of x based on base b.

example

1. mysql> select log(5,1);
2. +---------------+
3. | log(5.0, 1.0) |
4. +---------------+
5. |             0 |
6. +---------------+
7. mysql> select log(3,20);
8. +--------------------+
9. | log(3.0, 20.0)     |
10. +--------------------+
11. | 2.7268330278608417 |
12. +--------------------+
13. mysql> select log(2,65536);
14. +-------------------+
15. | log(2.0, 65536.0) |
16. +-------------------+
17. |                16 |
18. +-------------------+

keywords

1. LOG