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

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

Copyright © 2024 zkx4213
Powered by .NET 9.0 on Kubernetes