IS NULL is used in SQL to see whether there is a NULL value. True is returned if there is a null value. False otherwise.

Structure

[EXPRESSION] IS NULL

Example

Suppose we want to find a user who has null as the value in the last_name column in the users table. Here’s how to go about it:

SELECT *
FROM users
WHERE last_name IS NULL;