sign

description

Syntax

TINYINT sign(DOUBLE x) Returns the sign of x. Negative, zero or positive numbers correspond to -1, 0 or 1 respectively.

example

1. mysql> select sign(3);
2. +-----------+
3. | sign(3.0) |
4. +-----------+
5. |         1 |
6. +-----------+
7. mysql> select sign(0);
8. +-----------+
9. | sign(0.0) |
10. +-----------+
11. |         0 |
12. mysql> select sign(-10.0);
13. +-------------+
14. | sign(-10.0) |
15. +-------------+
16. |          -1 |
17. +-------------+
18. 1 row in set (0.01 sec)

keywords

1. SIGN