Find and replace data in MYSQL

By LotusshaneyTech

select * from [table_name];

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

Remove the Square brackets []