I realized this morning that I shouldn't have had you change the post-name to match the changes I made in the title because it is breaking people's links to my blog.
What I did is add the characters "review-" to the beginning of the post_name field. Now the links that are going to those pages are broken. What i would like to do is strip the characters "review-" so I am going to run this sql query
UPDATE wp_posts SET post_name = replace( post_name, ‘review-’, '' )
Then I would like to do an htaccess redirect to direct anyone who has a link to
to be redirected to http://dearauthor.com/wordpress/
Is this possible?
Is that possible (before I run the sql query)