MySQL - LOG10() Function

The MySQL LOG10() function accepts a numerical value as a parameter and returns the base-10 logarithm of the given value.

According to the mathematical definition, a logarithmic function of a number produces a result which is raised by its base to achieve the said number. The most common base values for a logarithms are 'e', 2, and 10. This function will calculate the logarithm of a number with base 10.

In other words, this method provides us the logarithm of any value for a base 10. It follows the formula given below −

log10a = result

Syntax

Following is the syntax of MySQL LOG10() function −

LOG10(X);

Parameters

This function takes a numeric value as a parameter.

Return Value

This function returns the base-10 logarithm of the given value.

Example

The following query uses MySQL LOG10() function to calculate the base-10 logarithm of the number 55 −

SELECT LOG10(55) As Result;

Output

This will produce the following result −

Result
1.7403626894942439

Example

Following is another example of this function, where we are calculating the base-10 logarithm of the decimal number 567439474.4684 −

SELECT LOG10(567439474.4684) As Result;

Output

The output for the query above is produced as given below −

Result
8.753919544620716

Example

If the value passed to the function is less than or equal to 0.0E0, it returns NULL.

Here, we are passing 0 as a parameter to this function −

SELECT LOG10(0) As Result;

The output is displayed as follows −

Result
NULL

Now, we are passing -6 as a parameter to this function −

SELECT LOG10(-6) As Result;

Following is the output −

Result
NULL

Example

You can also pass the numerical value as a string, to this function −

SELECT LOG10('2656') As Result;

Output

Following is the output −

Result
3.42422807069598

Example

The MySQL LOG10() function is equivalent to LOG(10, X). Following are the examples −

SELECT LOG(10, 44747) As Result;

The output is displayed as follows −

Result
4.650763923962105

Here, we are using the LOG10() function to calculate the base-10 logarithm of the number 44747 −

SELECT LOG10(44747) As Result;

As we can see the output below, both the LOG10() and LOG(10, X) results are same −

Result
4.650763923962105
Advertisements