MySQL – IS NULL

The MySQL IS NULL condition is used to check if an expression contains a NULL value. These statements are used with SELECT, INSERT, UPDATE, and DELETE.

Syntax

expression IS NULL  

expression – To determine if the value is NULL, it specifies a value.

Example:

SELECT *  
FROM employees  
WHERE first_name IS NULL;

Note:

In this case, first_name does not contain a NULL value, so the result is empty.