Bulk modify some of the contents of a field in a database (MySQL database replace usage)

That is, there will be a lot of content in a table, if you want to modify the contents of a field in the same data, such as the company name has been modified, then all occurrences of the company name in this field will have to be modified, if a change of course would be troublesome, if the amount of data is very large, modified very unrealistic, There must be something like the editor inside to replace all the functions;

Update the contents of a field, referring to all the columns in this field, such as the first column of the field is 123ASD, the second column is 456ASDF, want to replace as as, then the following statement will be executed after the two columns are all replaced;

Update indicates that the SET field name =replace (field name, ' Replace content ', ' replace content ');

Bulk modify some of the contents of a field in a database (MySQL database replace usage)