update table set f=replace(f,'_','-')
update table aset a.sn =replace(a.sn,'_','-')where instr(a.sn,'-',1) > 0希望能够帮到你，谢谢！
