w3resource

MySQL IS NULL

IS NULL

MySQL IS NULL operator tests whether a value is NULL. If satisfied, then returns 1 otherwise returns 0.

Syntax:

IS NULL

MySQL Version: 8.0

Example : MySQL IS NULL

In the following MySQL statement, it is checked whether 2, 0 and NULL are NULL, using IS NULL operator.

Code:

SELECT 2 IS NULL, 0 IS NULL, NULL IS NULL;

Output:

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

Slideshow of MySQL Comparison Function and Operators

Previous: IS NOT
Next: IS



Follow us on Facebook and Twitter for latest update.