Mass Empty a Category?

You can certainly do it with a custom query, but you need to remember that posts and categories are stored in post2cat as well!

you can always remove the category and create it again. (if you don’t want to remove the posts, because they will be moved to the default category.)

maerk: yes…the question is how do I go about doing it? x.x I’m a total nut when it comes to this.

marcrue: I am aware of that but I wish to retain the cat number, instead of increasing it everytime. =S

Well, to get rid of the post it would be something like:

DELETE * FROM wp_posts WHERE category_id = X

I’m not sure exactly of the right column name for category ID, you’ll have to check that.

NOTE I would be very wary about that query, I’m not sure if it’s correct, or what effects it will have on the rest of the system.

For example, I don’t know how to modify post2cat, which is also involved. Have a look at the database with phpMyAdmin and see if you can work something out, it probably wouldn’t be too hard.

Ahh…I see. Thanks a lot. I think I’ll need some SQL database lessons before I do anything. =P Meanwhile, I’ll wait for the plugin. *crosses fingers*

Thanks again!