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