w3resource

MySQL IS NOT NULL operator

IS NOT NULL operator

MySQL IS NOT NULL operator will check whether a value is not NULL.

Syntax:

IS NOT NULL

MySQL Version: 8.0

Example: MySQL IS NOT NULL operator

The following MySQL statement it is checked whether 5, 0 and NULL is not NULL.

Code:

SELECT 5 IS NOT NULL,0 IS NOT NULL, NULL IS NOT NULL;

Output:

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

Slideshow of MySQL Comparison Function and Operators

Previous: INTERVAL()
Next: IS NOT



Follow us on Facebook and Twitter for latest update.