MySQL Arithmetic Absolute Value and Sign (ABS, SIGN)
Example
Return the absolute value of a number
SELECT ABS(2); -> 2
SELECT ABS(-46); -> 46
The sign of a number compares it to 0.
| Sign | Result | Example |
|---|---|---|
| -1 | n < 0 | SELECT SIGN(42); -> 1 |
| 0 | n = 0 | SELECT SIGN(0); -> 0 |
| 1 | n > 0 | SELECT SIGN(-3); -> -1 |
SELECT SIGN(-423421); -> -1
