MySQL LOG() Function

Example

Return the natural logarithm of 2:

SELECT LOG(2);
Try it Yourself »

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

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);
Try it Yourself »

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.