UPDATE table SET field = NULL WHERE something = something
SELECT * FROM contacts WHERE last_name IS NULL;