Explanation

The operator that tests column for the absence of data is an is NULL operator. The NULL operator is used in the database for representing that a particular field is empty.

SELECT ‘column_name’

FROM ‘table_name’

WHERE ‘column_name’ IS NULL