Brief Introduction to mysql string replacement

Use update and replace to replace the specified string in mysql. For more information, see.

Use update and replace to replace the specified string in mysql. For more information, see.

Note:

Table_name -- table name
Field_name -- field name
From_str -- string to be replaced
To_str -- string to be replaced

Example 1

The Code is as follows:
UPDATE 'table _ name' SET 'field _ name' = replace ('field _ name', 'From _ str', 'to _ str ') WHERE 'field _ name' LIKE '% from_str %'

Example 2

For example, you want to replace the abc of the f1 field in Table tb1 with def.

The Code is as follows:
UPDATE tb1 SET f1 = REPLACE (f1, 'abc', 'def ');

Usage 1.

The Code is as follows:
Replace intoreplace into table (id, name) values ('1', 'A'), ('2', 'bb ')

This statement inserts two records into the table.