MySQL replaces a part of a field with an UPDATE statement _mysql

To replace some of the content in a field, you can use the UPDATE statement:

UPDATE table name SET field name = replace (field value before substitution, ' replace keyword ', ' replace keyword ') WHERE field name REGEXP "field value before replace";

For example, the price of the product in the replacement title is this way

Copy Code code as follows:

UPDATE dede_archives SET title= REPLACE (title, 155, 170);
UPDATE dede_archives SET title= REPLACE (title, 180, 230);
UPDATE dede_archives SET title= REPLACE (title, 270, 350);
UPDATE dede_archives SET title= REPLACE (title, 210, 170);
UPDATE dede_archives SET title= REPLACE (title, 155, 170);