MySQL replace () bulk replace the specified character implementation statement

The specific syntax for bulk substitution is:

The code is as follows	Copy Code
UPDATE Table name SET Specify field = replace (specify field, ' String to replace ', ' desired string ') WHERE condition;

If you want to have a record with an ID less than 5000 in the article table, replace "resolve" in the content field with "liberated", then the syntax is:

The code is as follows	Copy Code
UPDATE article SET Content = replace (content, ' resolve ', ' liberate ') WHERE id<5000;

The back where can be defined by themselves oh, well, like to see it.