How to delete multiple post meta keys with equal values?
-
Hi!
My plugin accidentally added several hundred custom fields to each post with the same key and the same value.
It looks like this:
my_key = 1234
my_key = 1234
my_key = 1234
my_key = 1234
my_key = 1234
my_key = 1234
my_key = 1234
my_key = 4321
my_key = 4321
my_key = 4321
my_key = 4321
my_key = 4321And so on. Is there an SQL delete statement which checks for the value and then delete all keys with the same content? The result should look like this:
my_key = 4321
my_key = 1234An idea? Around 30.000 posts have this probem. =/
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘How to delete multiple post meta keys with equal values?’ is closed to new replies.