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


for example,

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

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


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