I'm looking to move a number of old posts by one author from one category to another category and was hoping someone could help me do this?
I figure the easiest way would be through an SQL command?
I'm aware that you can bulk 'move' posts via the post editor screen but this only adds another category and doesn't in fact move the posts. There are a number of different plugins out there that can bulk move posts but none of them allow you to select specific users and specific dates.
In essence what I'm trying to achieve:
- select all posts from user with ID: 2
- IF posts are made before 15 Feb 2012 AND in category XYZ THEN move to category ABC
Any help would be greatly appreciated.