How can I search/replace strings in MySQL?
Programming and Web Development
SQL
MySQL lets you replace all occurrences of a character or string of characters in a table with some other character or string.UPDATE table SET field1 = REPLACE(field1, 'replace_that', 'with_this'), field2 = REPLACE(field2, 'and_that', 'with_this')As an example,...
