# **LOG10()**

## **Function Description**

The LOG10(X) function returns a logarithm with base 10 X.

## **Function Syntax**

```text
> LOG10(X)
```

## **Parameter definition**

| Parameters | Description |
|----|-------------------------------------------------------------------------------------------------------------------------
| X | Required parameters, any currently supported numerical data |

## **Example**

```text
drop table if exists t1;
create table t1(a float, b float);
insert into t1 values(10000,3784.159);
insert into t1 values(2738,682.325);

mysql> select log10(a),log10(b) from t1;
+------------------------------------------------------------------------------------------------------------------------------
| log10(a) | log10(b) |
+------------------------------------------------------------------------------------------------------------------------------
| 4 | 3.577969368581086 |
| 3.437433443797971 | 2.8339912916439594 |
+------------------------------------------------------------------------------------------------------------------------------
2 rows in set (0.00 sec)
```