IS NOT NULL
Anonymous contributor
Anonymous contributor3071 total contributions
Anonymous contributor
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
- Anonymous contributorAnonymous contributor3071 total contributions
- JeremyBarbosa18 total contributions
- BrandonDusch580 total contributions
- christian.dinh2476 total contributions
- Anonymous contributor
- JeremyBarbosa
- BrandonDusch
- christian.dinh
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.