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