mysql | Foster Solutions (FSI)

WordPress: SQL to Bulk Move Categories to Tags

There are tools out there but if you need to move all or most of the categories to tags then it is best to do it manually using SQL. Remember that category 1 is the default uncategorized so don’t move it. The code below allows you to select which category ids will not be moved …

Changing Media Attachment in WordPress (SQL)

WordPress seems limited with the way it handles images (media). I don’t see why it can’t be part of the taxonomy like posts and pages since it is stored in the wp_posts table. A media item is “attached” to a post if it has a value in the post_parent field. It can only be attached …