Example
Return the natural logarithm of 2:
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.
Syntax
LOG(number)
OR :
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):
SELECT LOG(2, 4);