How do I delete a row where the criteria on the row to be deleted is NULL.
An example, I have a table called images, and one of the columns is called location. So if I wanted to delete all the rows in the images table where the value in the location column = NULL, how do I create the query?
So far I have tried the following in my queries...
WHERE location = NULL;
WHERE location = 'NULL';
WHERE location = "NULL";