IS NOT NULL

BrandonDusch580 total contributions
Published Jun 25, 2021Updated Aug 18, 2022
Contribute to Docs
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;
All contributors
- BrandonDusch580 total contributions
- christian.dinh2481 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- JeremyBarbosa18 total contributions
- BrandonDusch
- christian.dinh
- Anonymous contributor
- JeremyBarbosa
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.