MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL LOG10() Function

The MySQL LOG10() function returns the base-10 logarithm of a given number. In special cases it returns the following:

  • If the number is less than or equal to 0, then NULL is returned.




number Required. Specify the number. Must be greater than 0.

Return Value

Returns the base-10 logarithm of a given number.

Example 1:

The example below shows the usage of LOG10() function.

mysql> SELECT LOG10(1);
Result: 0

mysql> SELECT LOG10(2);
Result: 0.3010299956639812

mysql> SELECT LOG10(3);
Result: 0.47712125471966244

mysql> SELECT LOG10(10);
Result: 1

mysql> SELECT LOG10(15);
Result: 1.1760912590556813

mysql> SELECT LOG10(0);
Result: NULL

Example 2:

Consider a database table called Sample with the following records:

Data 10.5
Data 21
Data 35
Data 410
Data 550

The query given below can be used to calculate the base-10 logarithm of column x.

SELECT *, LOG10(x) AS LOG10_Value FROM Sample;

This will produce the result as shown below:

Data 10.5-0.3010299956639812
Data 210
Data 350.6989700043360189
Data 4101
Data 5501.6989700043360187

❮ MySQL Functions