IS NULL

The IS NULL operator checks if a value is NULL.

Syntax

SELECT column_name(s)
FROM table_name
WHERE condition IS NULL;

Example

The given query will select all customers who do not have a birthday stored in the database.

SELECT *
FROM customers
WHERE birthday IS NULL;

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.

Learn SQL on Codecademy