Use of replace syntax for MySQL batch replacement

In practice, you need to replace the content of a field in a table in batches. The general thinking process is as follows:
Select
Replace str_replace
Update write
In fact, this is a waste of resources and resource consumption. MySQL has a built-in syntax for bulk replacement. CopyCodeThe Code is as follows: Update table set field = Replace (field, 'replaced', 'replaced ')

Replace it directly. You can also follow the where condition statement later.
Multiple words can be replaced at the same time.Copy codeThe Code is as follows: Update table set field = Replace (field, 'replaced with 1',' replaced with 1'), field = Replace (field, 'replaced with 2 ', 'replace with 2 ')

It's very powerful. The one-time replacement of multiple columns that are not available on the Internet is recorded now.