Find & Replace in MySQL

Thanks to all

Hi Arjun,


update tablename set columnname = (replace(columnname,'string_to_find','string_to_replace')


Example:-

UPDATE student SET sname=(REPLACE (sname,'Harry','Barry'))




Thanks

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