SQL IS NOT NULL

The IS NOT NULL operator checks if a value is not equal to NULL.

Syntax

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

Copy to clipboard
Copy to clipboard

Example

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

SELECT *
FROM customers
WHERE birthday IS NOT NULL;

Copy to clipboard
Copy to clipboard