SQL Script to Replace Text in MySQL Database

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

Leave a Reply