首页 > 代码库 > 11. 字符串替换例子:如:0.1.2.5.25.42替换为0,1,2,5,25,42

11. 字符串替换例子:如:0.1.2.5.25.42替换为0,1,2,5,25,42

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;

11. 字符串替换例子:如:0.1.2.5.25.42替换为0,1,2,5,25,42