MYSQL Bulk Replace the use of Replace syntax _mysql

In actual demand, the contents of a certain table must be replaced in bulk, the ordinary thinking process is as follows:
Select out
Str_replace replacement
Update Write
Actually this is extremely wasteful of resources and consumes resources, MySQL built-in a batch substitution syntax

Copy Code code as follows:

UPDATE table SET field = replace (field, ' replaced ', ' replace ')

It's replaced directly, and you can follow the WHERE condition statement
Support multiple words to be replaced at the same time

Copy Code code as follows:

UPDATE table SET field = replace (field, ' replaced by 1 ', ' Replace with 1 '), field = replace (field, ' replaced by 2 ', ' Replace with 2 ')

Very strong, the back of the one-time replacement of multiple online is not an odd, now recorded