Support » Fixing WordPress » Multiple Category change

  • Hi, Is there a way to modify the category of a number of given posts all at the same time? I’d like to move about 100 posts from one cat to another.

    Thanks!!!

Viewing 5 replies - 1 through 5 (of 5 total)
  • You might be able to do this using a mySQL query on your database. However I’m not much of an expert on these thing so I can’t give you any more info than that I’m afraid!

    Before beginning, do this:
    Step 1. Backup datbase
    Step 2. Make sure you do Step 1

    Using phpMyAdmin you can execute this sql command:

    UPDATE
    wp_post2cat SET category_id=10 WHERE category_id=25;

    This changes all records that have Category 25 to a Category of 10. Note you may have to change the prefix name (wp_) for “post2cat” to be your prefix.

    ********************
    Welcome to the WordPress Support Forums!

    Please help keep the Forums successful by reading:
    Using the Support Forums

    Also, remember the WordPress Codex and the FAQ pages.

    And, thank you, for letting us know if this information proves useful (or not)!
    ********************

    Batch Categories should do what you want.

    Thread Starter jmmo20

    (@jmmo20)

    thanks for the sql query but i wouldn’t want to change all posts of a given category, only those post old enough to be moved from the category “podcast” to “archive”

    Thanks for the batch category plug in 🙂

    jmmo20–yeah, without being able to specify the criteria of what posts to change then changing the Category individually on each post is the most accurate approach.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Multiple Category change’ is closed to new replies.