【问】批量删除ESHOP商业4中，商品名称中的逗号
【适用版本】eShop商业4	【模块】基础档案	【点击数】30
【知识编号】E2017083000001
【问题描述】批量删除ESHOP商业4中，商品名称中的逗号

【答】 请备份数据库执行以下语句，以下包含大多的特殊字符：use eshop4update t_bd_item_info  set item_size   =  replace (item_size,'(‘,'(‘) where item_size    like’%（%’
update t_bd_item_info  set item_name   =  replace (item_name,'(‘,'(‘)   where item_name    like’%（%’
update t_bd_item_info  set item_name   =  replace (item_name,’)’,’)’)   where item_name    like’%）%’
update t_bd_item_info  set item_name   =  replace (item_name,’！’,”)   where item_name    like’%！%’
update t_bd_item_info  set item_subname=  replace (item_subname,’！’,”)where item_subname like’%！%’
update t_bd_item_info  set item_name   =  replace (item_name,’：’,”)   where item_name    like’%：%’
update t_bd_item_info  set item_subname=  replace (item_subname,’：’,”)where item_subname like’%：%’
update t_bd_item_info  set item_name   =  replace (item_name,’｛’,”)   where item_name    like’%｛%’
update t_bd_item_info  set item_subname=  replace (item_subname,’｛’,”)where item_subname like’%｛%’
update t_bd_item_info  set item_name   =  replace (item_name,’，’,”)   where item_name    like’%，%’
update t_bd_item_info  set item_subname=  replace (item_subname,’，’,”)where item_subname like’%，%’
update t_bd_item_info  set item_name   =  replace (item_name,’＃’,”)   where item_name    like’%＃%’
update t_bd_item_info  set item_subname=  replace (item_subname,’＃’,”)where item_subname like’%＃%’
update t_bd_item_info  set item_name   =  replace (item_name,’。’,”)   where item_name    like’%。%’
update t_bd_item_info  set item_subname=  replace (item_subname,’。’,”)where item_subname like’%。%’
update t_bd_item_info  set item_name   = replace(item_name,’、’,’-‘) where item_name    like ‘%、%’ 
update t_bd_item_info  set item_subname= replace(item_subname,’、’,’-‘) where item_subname like ‘%、%’
update t_bd_item_info  set item_name   = replace(item_name,’、’,’-‘) where item_name    like ‘%、%’ 
update t_bd_item_info  set item_name= replace(item_name,’%’,”)   where item_name like’%[%]%’
update t_bd_item_info  set item_subname= replace(item_subname,’%’,”) where item_subname like’%[%]%’