Delete empty rows

Question

I use PostgreSQL database and in one table I have the datetime column edit_user. Some rows are blank, and these rows I would like to delete. I tried ``` DELETE FROM table WHERE edit_user=""; ``` but I got the error LINE 1: delete from table where edit_user=""; Also, I thought in the column as a blank value could be 0000-00-00, but there isn't. How I should execute this command correctly?

Accepted Answer

```
DELETE FROM table WHERE edit_user IS NULL;
```

Delete empty rows

Solution

Problem