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.
[EXPRESSION] IS NULL
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;