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.