In MySQL, the SIGN()
function returns the sign of a number. That is, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the value as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero