COALESCE(value,...) returns the first non-NULL value in the list, or NULL if there are no non-NULL values : BETWEEN AND « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. BETWEEN AND
mysql>
mysql> SELECT COALESCE(NULL,1);
+------------------+
| COALESCE(NULL,1) |
+------------------+
|                1 |
+------------------+
1 row in set (0.00 sec)

mysql>
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