Skip to content

WordPress Search and Replace using phpMyAdmin

The following method I use to search and replace text on WordPress using phpMyAdmin.

In WordPress, If you have changed the default Table Prefix; that needs to reflect wp_posts.

And finally, replace FIND/REPLACE texts with the appropriate ones.

UPDATE wp_posts SET post_content = REPLACE (  
post_content,  
'FIND',  
'REPLACE');
comments powered by Disqus