Forums

[resolved] How can i delete a custom field from all posts? (3 posts)

  1. 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.

  2. Kafkaesqui
    Moderator
    Posted 2 years ago #

    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.

  3. Dgold
    Member
    Posted 2 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic