expr BETWEEN min AND max : BETWEEN AND « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. BETWEEN AND

expr NOT BETWEEN min AND max is the same as NOT (expr BETWEEN min AND max).

If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1.

Otherwise it returns 0.

This is equivalent to the expression (min <= expr AND expr <= max).

mysql>
mysql> SELECT 1 BETWEEN 2 AND 3;
+-------------------+
| 1 BETWEEN 2 AND 3 |
+-------------------+
|                 0 |
+-------------------+
1 row in set (0.00 sec)

mysql>








15.2.BETWEEN AND
15.2.1.expr BETWEEN min AND max
15.2.2.SELECT 'b' BETWEEN 'a' AND 'c';
15.2.3.SELECT 2 BETWEEN 2 AND '3';
15.2.4.SELECT 2 BETWEEN 2 AND 'x-3';
15.2.5.COALESCE(value,...) returns the first non-NULL value in the list, or NULL if there are no non-NULL values