Example
Return the natural logarithm of 2:
sql
SELECT LOG(2);
Definition and Usage
The LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
Note: See also the LN() and EXP() functions.
Syntax
text
LOG(number)
OR:
text
LOG(base, number)
Parameter Values
| Parameter | Description |
|---|---|
| number | Required. A number. Must be greater than 0 |
| base | The base of number. Must be greater than 1 |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the natural logarithm of 4 to a specified base (2):
sql
SELECT LOG(2, 4);