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

by

[ad_1]

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

[ad_2]

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