ABS

Returns the absolute value of x.

Syntax

ABS(x)

Examples

MySQL [(none)]> select ABS(-5);
+---------+
| ABS(-5) |
+---------+
|       5 |
+---------+

MySQL [(none)]> select ABS(-5.5);
+-----------+
| ABS(-5.5) |
+-----------+
|       5.5 |
+-----------+