SELECT 2 BETWEEN 2 AND 'x-3'; : BETWEEN AND « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. BETWEEN AND
mysql>
mysql> SELECT 2 BETWEEN 2 AND 'x-3';
+-----------------------+
| 2 BETWEEN 2 AND 'x-3' |
+-----------------------+
|                     0 |
+-----------------------+
1 row in set, 1 warning (0.01 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