MySQL Function Reference

SIGN

Returns the sign of the given number: -1 for negative values, 1 for positive values, and 0 for 0

MySQL 8.1

SIGN([num])

Examples

MySQL 8.1

SELECT SIGN(-2);

MySQL 8.1

SELECT SIGN(2);

MySQL 8.1

SELECT SIGN(0);