UPDATE `TABEL_NAME`
 SET `FIELD NAME` = replace(`FIELD NAME`, 'unwanted Text', 'Wanted Text')

 

for example,


UPDATE `wp_options`
 SET `option_value` = replace(`option_value`, '192.168.1.174', '192.168.1.188');
 
 UPDATE `wp_postmeta`
 SET `meta_value` = replace(`meta_value`, '192.168.1.174', '192.168.1.188');

 UPDATE `wp_posts`
 SET `post_content` = replace(`post_content`, '192.168.1.174', '192.168.1.188');
 
 UPDATE `wp_posts`
 SET `guid` = replace(`guid`, '192.168.1.174', '192.168.1.188');

 

Leave a Reply