austindefender

Criminal defense in Austin Texas.

Bitchin’ about WordPress

Posted By 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'll never meet a customer ourselves.

Bear in mind, we


Comments

Leave a Reply

Security Code:

%d bloggers like this: