29Apr/10Off
MySQL: Global find & replace
Global find & replace is easy in MySQL:
UPDATE table_name SET column_name = replace(column_name, "searchString", "replaceString");
Global find & replace is easy in MySQL:
UPDATE table_name SET column_name = replace(column_name, "searchString", "replaceString");