Use of MYSQL batch substitution replace syntax

  • 2020-05-27 07:20:56
  • OfStack

In the actual demand, the contents in a certain table and a certain field need to be replaced in batches. The common thinking process is as follows:
SELECT out
str_replace replacement
UPDATE write
In fact, this is extremely wasteful and consumes resources. MYSQL has a batch substitution syntax built in

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

I'm just going to do it, and I can also do it with WHERE
Support for multiple word substitutions at the same time

UPDATE table SET field = replace(field,' Be replaced 1',' replace 1'),field = replace(field,' Be replaced 2',' replace 2')  

Very powerful, the latter 1 time sex change many is not on the net the column son, now record down

Related articles: