SQL Script to Replace Text in MySQL Database
If you wonder how to mass editing the content of your Wordpress posts, here is the SQL script that helps you change texts of your Wordpress posts quickly.
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`,”ORIGINAL TEXT”, “REPLACE TEXT”)
ORIGINAL TEXT is the text that you want to replace
REPLACE TEXT is the new text that you want replace ORIGINAL TEXT