LOG2 Mysql function to get logarithm with base 10 using MySQL query

SELECT LOG2(7); // Output is 2.8073549220576
SELECT LOG2(0.1); // Output is -3.32192809488736
SELECT LOG2(0); // Output is NULL

Using ROUND() with LOG()

SELECT ROUND(LOG2(8),2);// Output is 3.00
SELECT ROUND(LOG2(-5),2); // Output is NULL
SELECT ROUND(LOG2(9),2); // Output is 3.17

Syntax

SELECT LOG2( X )

Returns natural logarithm of X with base 2. When X is less than or equal to 0.0E0 we get NULL as output.
SQL Math References LOG10() LOG()

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

LOG2() : natural logarithm of X with base 2

Using ROUND() with LOG()

Subhendu Mohapatra