MySQL WordPress Database concat help needed
-
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:
UPDATE
wp_posts
SET post_name = replace( post_name, ‘review-‘, ” ) WHERE post_modified < 2007-08-30It’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.
UPDATE
wp_posts
SETpost_name
= CONCAT(post_name
, ‘review-‘) WHERE post_modified > 2007-08-30
- The topic ‘MySQL WordPress Database concat help needed’ is closed to new replies.