[Solved] How to delete mySQL records that are empty? [closed]

by


If your meta_key is null you can use

delete from your_table
where meta_key is null

If it is just an empty string use

delete from your_table
where meta_key = ''

and if your meta_key contains just spaces then use (which could run slower)

delete from your_table
where trim(meta_key) = ''

3

solved How to delete mySQL records that are empty? [closed]