SELECT 'b' BETWEEN 'a' AND 'c'; : BETWEEN AND « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. BETWEEN AND
mysql>
mysql> SELECT 'b' BETWEEN 'a' AND 'c';
+-------------------------+
| 'b' BETWEEN 'a' AND 'c' |
+-------------------------+
|                       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