Mega Code Archive

 

Categories / MySQL / Data Type

 

Use the IS NULL (or IS NOT NULL) comparison instead

mysql> mysql> SELECT NULL IS NULL; +--------------+ | NULL IS NULL | +--------------+ |            1 | +--------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 4.5 BETWEEN 4 and 5; +---------------------+ | 4.5 BETWEEN 4 and 5 | +---------------------+ |                   1 | +---------------------+ 1 row in set (0.00 sec)