MySQL - Removing null value rows from table

Question

I have a table "user" with over 60 columns. One of the column's name is "username"

I want to remove the rows where the username field is empty or NULL

How can I do this?

Thank you!

Answer 1

Try this

DELETE FROM user WHERE username IS NULL;

or

DELETE FROM user WHERE username = '';

Problems with NULL Values

Answer 2

If you want to delete all those rows containing username = NULL AND where username is empty string ("") as well

then

DELETE FROM table_name WHERE username IS NULL OR username = '';

It is advised to first do a SELECT query with same WHERE condition as that you are going to use in DELETE query to see which rows will be deleted:

SELECT * FROM table_name WHERE username IS  NULL OR username = "";