Find and Replace Text in WordPress MySQL Database

In absence of using a WordPress plugin to do this task, it is possible to find every instance of a particular text string within your posts and replace them.

Simply login to your PHPMyAdmin page and input this query:

UPDATE wp_posts SET post_content = REPLACE (post_content, 'TEXT TO REPLACE', 'REPLACEMENT TEXT');

Leave a Reply

Your email address will not be published. Required fields are marked *