替换字段 update tb_goods set specifications_unit=REPLACE(specifications_unit,’&’,’;’) where specifications_unit like’%&%’;