首页 › Informix › Informix 数据库字段replace

snowdymy 发表于 2013-1-14 23:25:25

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 '%：%' ;

查看完整版本: Informix 数据库字段replace