How to calculate the natural logarithm of a given number using the LN() function?

LN(X, Y) is a MySQL built-in function that calculates the natural logarithm of a given number. For example:

SELECT LN(2.71828), LN(1), LN(0.367879);
  -- +-------------------+-------+---------------------+
  -- | LN(2.71828)       | LN(1) | LN(0.367879)        |
  -- +-------------------+-------+---------------------+
  -- | 0.999999327347282 |     0 | -1.0000011992290339 |
  -- +-------------------+-------+---------------------+

Reference information of the LN() function:

LN(X): val
  Returns the natural logarithm of X; that is, the base-e logarithm of
  X. If X is less than or equal to 0.0E0, the function returns NULL.

  This function is synonymous with LOG(X). The inverse of this function is
  the EXP() function.

Arguments, return value and availability:
  X: Required. The input value.
  val: Return value. The natural logarithm of X.
  Available since MySQL 4.0.

Related MySQL functions:

• EXP() - Exponential Based on E

⇒ LOG() - Logarithm of Y to Base X

⇐ INTERVAL() - Interval Position of Sorted List

⇑ MySQL Functions on Numeric Values

⇑⇑ MySQL Function References