Sqlite: how to delete rows that contain null/empty strings

Question

First of all thanks for your help. I do an learning SQL, so I need some help.

I have a Sqlite database in which some fields in a certain column contains nothing or string of spaces.

Please How do I delete the rows containing nothing (or string of spaces) from the database?

Thanks for your help.

Answer 1

Try this:

DELETE FROM myTable WHERE myColumn IS NULL OR trim(myColumn) = '';

The trim() is necessary so that strings containing just whitespace are collapsed to an empty string.

Answer 2

Try this:

DELETE FROM tbl
WHERE
  (filed IS NULL OR filed  = '')

Multiple Column:

DELETE FROM tbl
WHERE
  (filed IS NULL OR filed  = '')
  AND (filed2 IS NULL OR filed2 = '')
  AND (filed3 IS NULL OR filed2 = '')