Illphated
Here’s the SQL command to update WordPress posts and titles containing “Audrey” to “Audrey Montgomery”:
sqlCopyUPDATE wp_posts
SET
post_title = REPLACE(post_title, ‘Audrey’, ‘Audrey Montgomery’),
post_content = REPLACE(post_content, ‘Audrey’, ‘Audrey Montgomery’)
WHERE
post_title LIKE ‘%Audrey%’
OR post_content LIKE ‘%Audrey%’;
A few important notes:
Make sure to backup your database before running this command
This will replace all instances of “Audrey” with “Audrey Montgomery”, even if “Audrey” is part of another word
If your WordPress database uses a different prefix than “wp_”, you’ll need to adjust “wp_posts” accordingly
Just replace the wordpress post table to correct on top