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.
expression IS NULL
expression – To determine if the value is NULL, it specifies a value.
SELECT * FROM employees WHERE first_name IS NULL;
In this case, first_name does not contain a NULL value, so the result is empty.