Tag Archives: How to find and replace in mysql

To find a string in a certain field and replace it with another string: update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);   update `wp_posts` set `post_content` = replace(`post_content`,’http://localhost/elrashd/holding/’,’http://elrashad.promolinks.com/’)