IS NOT NULL : IS NULL ISNULL : Comparison Functions Operators MySQL TUTORIALS

MySQL TUTORIALS » Comparison Functions Operators » IS NULL ISNULL »

IS NOT NULL


mysql>
mysql> SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
+---------------+---------------+------------------+
| 1 IS NOT NULL | 0 IS NOT NULL | NULL IS NOT NULL |
+---------------+---------------+------------------+
|             1 |             1 |                0 |
+---------------+---------------+------------------+
1 row in set (0.00 sec)

mysql>