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

Posted on 2014-11-20 12:56  zkx4213  阅读(114)  评论(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;

博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3