vexxatu
Member
Posted 2 years ago #
Hey,
I have installed a plugin recently that added to every post from my blog 3 custom fields.This is a rating plugin and has added to every post 3 custom fields with values.
The problem is i want to delete those and I do not want to do it manually because i have 700+ posts.I know those are stored probably in wp-postmeta but i couldn't find anything there to delete.Any advices?
ps. unistalling the plugin or removing its table from sql doesnt resolve this.
As long as you're certain of the keys to the custom fields you want to delete, you can use the following SQL DELETE query:
DELETE FROM wp_postmeta WHERE meta_key = 'PLUGIN_KEY';
If using a different table prefix than the default 'wp_', make sure the name of the postmeta table in your query reflects that.
Cool, I might have to try that to get rid of Autometa. I tried that plugin for a couple weeks, now I'm trying Ultimate Tag Warrior.... just trying to decide how to handle some per-post "tags". Anyway it seems like I have some useless Autometa custom fields populated on an unknown number of posts.
So, thanks for the info!