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');

 

One Comment

  • You actually make it seem so easy with your presentation but I find this topic to be actually something that I think I would never understand. It seems too complicated and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

Leave a Reply