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;

原文地址:https://www.cnblogs.com/zkx4213/p/4110345.html