1、批量修改某字段字符串为空 UPDATE ecs_goods SET goods_name=REPLACE(goods_name, '某字符串', '') where goods_name like '%?%'