Use SIGN function : SIGN « Function « SQL / MySQL

1. SQL / MySQL
2. Function
3. SIGN

Use SIGN function

/*
SIGN function returns the sign of the supplied value X as -1, 0, or 1, 
depending on whether the value X is negative, zero, or positive, respectively. 
*/
select SIGN(0);
select SIGN(-3);
select SIGN(3);
/*
mysql> select SIGN(0);
+---------+
| SIGN(0) |
+---------+
|       0 |
+---------+
1 row in set (0.00 sec)

mysql> select SIGN(-3);
+----------+
| SIGN(-3) |
+----------+
|       -1 |
+----------+
1 row in set (0.00 sec)

mysql> select SIGN(3);
+---------+
| SIGN(3) |
+---------+
|       1 |
+---------+
1 row in set (0.00 sec)


*/
           
       

Related examples in the same category