Find & Replace in MySQL

Question

Hi Plz reply this - I try to Find & Replace Data in MySQL ? Thanks

Arjun Panwar · Answer

Thanks to all

Satyapriya Nayak · Answer

Hi Arjun update tablename set columnname = (replace(columnname'string_to_find''string_to_replace') Example:- UPDATE student SET sname=(REPLACE (sname'Harry''Barry')) Thanks

Chintan Rathod · Answer

Syntax : UPDATE table_name SET field_name = replace( field_name 'string_to_find' 'string_to_replace' ) ; Example  UPDATE wp_comments SET author_url = replace( author_url 'http://website' 'http://website.com/' ) ;