SELECT 2 BETWEEN 2 AND '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 '3';
+---------------------+
| 2 BETWEEN 2 AND '3' |
+---------------------+
|                   1 |
+---------------------+
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