UPDATE `tableName` SET `fieldName` = replace(`fieldName`, 'fromString', 'toString') WHERE `fieldName` LIKE '%fromString%';
- 注释:
- tableName:表名
- fieldName:字段名
- fromString:要替换的字符串
- toString:替换成的字符串
月照山兮 山有径 月照海兮 海有舟
UPDATE `tableName` SET `fieldName` = replace(`fieldName`, 'fromString', 'toString') WHERE `fieldName` LIKE '%fromString%';
- 注释:
- tableName:表名
- fieldName:字段名
- fromString:要替换的字符串
- toString:替换成的字符串