Informix 数据库字段replace
update informix.t_nameinfo setcode=replace(code,'；','*') where code like '%；%' ;Select * from informix.t_nameinfowhere code like '%；%' ;
update informix.t_nameinfo setcode=replace(code,'：','-') where code like '%：%' ;
Select * from informix.t_nameinfowhere code like '%：%' ;
update informix.t_nameinfo setstandardname=replace(standardname,'；','*') where standardname like '%；%' ;
Select * from informix.t_nameinfowhere standardname like '%；%' ;
update informix.t_nameinfo setstandardname=replace(standardname,'：','-') where standardname like '%：%' ;
Select * from informix.t_nameinfowhere standardname like '%：%' ;
页:
[1]