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!

Accepted Answer

Try this

```
DELETE FROM user WHERE username IS NULL;
```

or

```
DELETE FROM user WHERE username = '';
```

Problems with NULL Values

MySQL - Removing null value rows from table

Solution

Problem