INTERVAL(N,N1,N2,N3,...): Returns 0 if N < N1, 1 if N < N2 and so on or -1 if N is NULL : INTERVAL « Comparison Functions Operators « MySQL Tutorial

1. MySQL Tutorial
2. Comparison Functions Operators
3. INTERVAL

mysql>
mysql> SELECT INTERVAL(2, 1, 5, 7, 3, 4, 2);
+-------------------------------+
| INTERVAL(2, 1, 5, 7, 3, 4, 2) |
+-------------------------------+
|                             1 |
+-------------------------------+
1 row in set (0.03 sec)

mysql> SELECT INTERVAL(10, 12, 11, 1, 10);
+-----------------------------+
| INTERVAL(10, 12, 11, 1, 10) |
+-----------------------------+
|                           0 |
+-----------------------------+
1 row in set (0.00 sec)

mysql> SELECT INTERVAL(2, 3, 0, 4, 2);
+-------------------------+
| INTERVAL(2, 3, 0, 4, 2) |
+-------------------------+
|                       0 |
+-------------------------+
1 row in set (0.01 sec)

mysql>
mysql>
mysql>