Mark_Co
asked on
Deleting row with a blank column value
i have a person table in SQL and i have columns: id, lastname, firstname, address, city.
City for a person is empty so i want a query to delete the row containing the person with a blank city column value. The code below didn't do it even though no errors were raised.
Thanks
City for a person is empty so i want a query to delete the row containing the person with a blank city column value. The code below didn't do it even though no errors were raised.
DELETE FROM persons pers
WHERE lastname = 'saire' AND address = 'NULL'
Thanks
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you!
Address IS NULL