sql 批量匹配截取替换字段

UPDATE 表名
SET 字段名 = REPLACE(字段名, '要替换的关键词', '替换后的关键词')
WHERE 条件;

UPDATE activity_commodity
SET commodity_picture = REPLACE(commodity_picture, 'hewa-activity-public', 'hewa-activity-pro');