TRANSMISSION_ID: 2025-02-09-sql-command-to-replace-words-in-wordpress-posts-and-title
SQL command to replace words in wordpress posts and title
DATE: 2025-02-09 01:51:36
STATUS: PUBLISHED
AUTHOR: 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
END OF TRANSMISSION // ILLPHATED.COM