11. 字符串替换例子:如:0.1.2.5.25.42替换为0,1,2,5,25,42
Posted on 2014-11-20 12:56 zkx4213 阅读(103) 评论(0) 编辑 收藏 举报select * from lborganization c where instr(replace((SELECT b.fdncode from TUSER a inner join LBORGANIZATION b on a.ORGID=b.id where a.id=1),'.',','),id)>0;