Example
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.
Author: Mostafa
MySQL LOG10 Function
Example
Return the base-10 logarithm of 2:
SELECT LOG10(2);
Definition and Usage
The LOG10() function returns the natural logarithm of a number to base-10.
Syntax
LOG10(number)
Parameter Values
| Parameter | Description |
|---|---|
| number | A number greater than 0 |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the base-10 logarithm of 4.5:
SELECT LOG10(4.5);
MySQL LOG Function
Example
Return the natural logarithm of 2:
SELECT LOG(2);
Definition and Usage
The LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base. Continue reading MySQL LOG Function
MySQL LN Function
Example
Return the natural logarithm of 2:
SELECT LN(2);
Definition and Usage
The LN() function returns the natural logarithm of a number.
Note: See also the LOG() and EXP() functions. Continue reading MySQL LN Function
MySQL LEAST Function
Example
Return the smallest value of the list of arguments:
SELECT LEAST(3, 12, 34, 8, 25);
Definition and Usage
The LEAST() function returns the smallest value of the list of arguments.
Note: See also the GREATEST() function. Continue reading MySQL LEAST Function
MySQL GREATEST Function
Example
Return the greatest value of the list of arguments:
SELECT GREATEST(3, 12, 34, 8, 25);
Definition and Usage
The GREATEST() function returns the greatest value of the list of arguments.
Note: See also the LEAST() function. Continue reading MySQL GREATEST Function
MySQL FLOOR Function
Example
Return the largest integer value that is less than or equal to 25.75:
SELECT FLOOR(25.75);
Definition and Usage
The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
Note: Also look at the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions. Continue reading MySQL FLOOR Function
MySQL EXP Function
Example
Return e raised to the power of 1:
SELECT EXP(1);
Definition and Usage
The EXP() function returns e raised to the power of the specified number.
The constant e (2.718281…), is the base of natural logarithms.
Tip: Also look at the LOG() and LN() functions. Continue reading MySQL EXP Function
MySQL DIV Function
Example
Integer division (10/5):
SELECT 10 DIV 5;
Definition and Usage
The DIV function is used for integer division (x is divided by y). An integer value is returned. Continue reading MySQL DIV Function
MySQL DEGREES Function
Example
Convert the radian value into degrees:
SELECT DEGREES(1.5);
Definition and Usage
The DEGREES() function converts a value in radians to degrees.
Note: See also the RADIANS() and PI() functions. Continue reading MySQL DEGREES Function