Bitchin’ about WordPress
Posted By Lance Stott on December 24, 2008
Ok, so I’ve been very lazy, and I haven’t made any categories. So log on today, intending to make at least two categories (law & economics)… and assign all my posts to one or the other. Only, there doesn’t seem to be any way to do that. So I pull up my trusted friend “Google” and do a search, and here’s what I find:
HOW TO BULK ASSIGN UNASSIGNED POSTS TO A CATEGORY IN WORDPRESS
First, we need to generate a list of all of the post IDs that correspond to posts that have no category. To do this, we are going to combine individual columns from two tables: the ‘ID‘ column of wp_posts, and the ‘object_id‘ column of wp_term_relationships. With each of those tables, I clicked the Export tab and used the ‘CSV for MS Excel’ format. I clicked the ‘Save as File’ checkbox and downloaded the resulting files to my computer.
There are about 73 more paragraphs following this one, but my brain died after wp_term_relationships. So I had to stop reading.
Bear in mind, we
Comments
Leave a Reply