Syntax:SIGN(X)Returns the sign of the argument as -1, 0, or 1, depending on whether Xis negative, zero, or positive.
mysql> SELECT SIGN(-32); -> -1mysql> SELECT SIGN(0); -> 0mysql> SELECT SIGN(234); -> 1