IS NULL
The IS NULL
operator checks if a value is NULL
.
Syntax
SELECT column_name(s)FROM table_nameWHERE condition IS NULL;
Example
The given query will select all customers who do not have a birthday
stored in the database.
SELECT *FROM customersWHERE birthday IS NULL;