背景:
例如A表存在字段,第一行值为华为SPN,第二行值为华为PTN,第三行为华为OTN,第四行为烽火SPN,现在要把所有的SPN都替换为SPTN
1、创建表
CREATE TABLE A ( id INT PRIMARY KEY, name VARCHAR(255) );
2、插入数据
INSERT INTO A (id, name) VALUES (1, '华为SPN');
INSERT INTO A (id, name) VALUES (2, '华为PTN');
INSERT INTO A (id, name) VALUES (3, '华为OTN');
INSERT INTO A (id, name) VALUES (4, '烽火SPN');
3、替换所有SPN为SPTN:
UPDATE A SET name = REPLACE(name, 'SPN', 'SPTN');
4、查询现有数据
+----+----------------+
| id | |
+----+----------------+
| 1 | {"name": "华为SPTN"} |
| 2 | {"name": "华为PTN"} |
| 3 | {"name": "华为OTN"} |
| 4 | {"name": "烽火SPTN"} |
+----+----------------+