how to get null field only in mysql records with in condition code example Example: mysql where value is null SELECT * FROM contacts WHERE last_name IS NULL;