I use MySQL and I have a problem with my query.
DELETE FROM users WHERE user_address = NULL;
Why I can't delete row where column is NULL?
I don't get any errors from database and data is not removed after I execute the above query.
DELETE FROM users WHERE user_address IS NULL;
Sometimes your data can be empty string. You can delete row with below query:
DELETE FROM users WHERE user_address = '';