I've screwed up my database a bit in terms of the permalinks. I didn't really think through what would happened when I changed the post_name to match the changes to the post_title.
What I would like to do is change all of the posts after 8/30/07 to start with "revew-" in the post_name field and all the posts before 8/30/07 to not start with "review-"
I know how to effectuate the last issue:
wp_posts SET post_name = replace( post_name, 'review-', '' ) WHERE post_modified < 2007-08-30
It's the first part that I have issue with. Concat appends the data and I want to insert it at the beginning of the field.
post_name = CONCAT(
post_name, 'review-') WHERE post_modified > 2007-08-30