[wp-hackers] Category table

John Blackbourn johnbillion+wp at gmail.com
Sun Aug 24 17:30:21 GMT 2008

Avoiding the question slightly, you could get the desired outcome as follows:

1. Create your new category if you haven't already (or decide which
existing category you're going to move these posts into).
2. Set this category as the default category via the Manage ->
Categories screen.
3. On the same screen, delete the Uncategorised category.

The act of deleting a category will move all the posts in it into the
default category.

If you don't want the aforementioned category to remain as the
default, choose another (or create another) and set that as the

Don't forget to do a database backup beforehand!

Hope this helps.


On Sun, Aug 24, 2008 at 6:14 PM, Elliotte Harold <elharo at metalab.unc.edu> wrote:
> I need to do some maintenance to move all the uncategorized posts into one
> particular category on one of my blogs. I thought I'd just do a quick SQL
> command. However, wp_posts.post_category seems to be 0 for all except one
> post on the blog so I'm thinking I'm not looking in the right place. Where
> in the tables does WordPress (2.5 if that matters) store the information
> about which posts are in which categories?
> --
> Elliotte Rusty Harold  elharo at metalab.unc.edu
> Refactoring HTML Just Published!
> http://www.amazon.com/exec/obidos/ISBN=0321503635/ref=nosim/cafeaulaitA
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

More information about the wp-hackers mailing list