mass change of category?

  • Is there a way to change category on a large number of posts at once? Basically, I’m trying to avoid a long night of editing every post (hundreds of them) by hand. Thanks.

Viewing 8 replies - 1 through 8 (of 8 total)

  • Yes, you can do that by using phpMyAdmin to change that field directly in your mysql database.
    Is it that you want to change the name of the category or the post/category combination?

    https://climbtothestars.org/archives/2004/07/13/batch-categories-09/
    This may help too.

    Thread Starter Anonymous

    Thanks. Much better than by hand.

    I’m bumping this up because I’d like to do the same, but with over 6,000 entries even using the plugin would take me forever. (Yes, I did edit the code to make it show more than 20 at a time. It’s still going to take all night at the rate of 200 per screen.)

    Could someone share the query structure I’d need to run in phpMyAdmin to do this, please?

    Lorelle

    (@lorelle)

    update tablename set field = replace(field,'search_for_this','replace_with_this');

    a specific example is to change all posts from ping status open to closed:
    UPDATE wp_posts SET ping_status = REPLACE (
    ping_status,
    'open',
    'closed');

    BACKUP FIRST.

    venomous_kate

    (@venomous_kate)

    Cool beans. I’ll give that a try. Thank you!

    Does this plugin work with the most current version of WP? I can’t seem to get it to run.

    It works like a charm, although she’s not kidding about it being a resource hog. Then again, I have 3600 some-odd posts, so there’s a lot for it to move around.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘mass change of category?’ is closed to new replies.