IS NULL

BrandonDusch's avatar
BrandonDusch's avatar
BrandonDusch
Published Jun 25, 2021Updated Aug 18, 2022
Contribute to Docs

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;

All contributors

Contribute to Docs

Learn SQL on Codecademy