LOG mysql function to get natural logarithm with different base value using MySQL query

Using ROUND() with LOG()

SELECT ROUND(LOG(2),2);// Output is 0.69
SELECT ROUND(LOG(-2),2); // Output is NULL
SELECT ROUND(LOG(6,3),2); // Output is 0.61

If Base is less than or equal to 1 then NULL is returned, similarly if X is less than or equal to 0 then NULL is returned.

SELECT LOG( 6, -0.1 ); Output is NULL
SELECT LOG( -6, 2 ); // Output is NULL
SELECT LOG( 6, 0.1 ) // Output is -1.28509720893847

Syntax

SELECT LOG( X )

Returns natural logarithm of X. We cap add one more argument to specify Base.

SELECT LOG( B,X )

X is the number and B is the base. The output is log value of X with base B.
SQL Math References LOG10() to get Log value with base 10 Average value Query

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

LOG(): to get natural logarithm with different base values

Using ROUND() with LOG()

Subhendu Mohapatra