MySQL LOG2() Function

Return the base-2 logarithm of 6:

SELECT LOG2(6);

Definition and Usage

The LOG2() function returns the natural logarithm of a number to base-2.

Note: See also the LOG() function.

LOG2( number)

Parameter	Description
number	A number. Must be greater than 0

Works in:	From MySQL 4.0

Return the base-2 logarithm of 64:

SELECT LOG2(64);