=, <, or <>. To compare the fields with NULL values, you have to use the IS NULL and IS NOT NULL operator.NULL and IS NOT NULL.SELECT column_names FROM table_name WHERE column_name IS NULL;
SELECT column_names FROM table_name WHERE column_name IS NOT NULL;