UPDATE 表名
SET 字段名 = REPLACE(字段名, '要替换的关键词', '替换后的关键词')
WHERE 条件;
UPDATE activity_commodity
SET commodity_picture = REPLACE(commodity_picture, 'hewa-activity-public', 'hewa-activity-pro');
sql 批量匹配截取替换字段
发布时间 2023-11-29 16:11:37作者: 飞离地平线
UPDATE 表名
SET 字段名 = REPLACE(字段名, '要替换的关键词', '替换后的关键词')
WHERE 条件;
UPDATE activity_commodity
SET commodity_picture = REPLACE(commodity_picture, 'hewa-activity-public', 'hewa-activity-pro');