SELECT count(0) FROM LMDN a WHERE EXISTS
(SELECT * FROM APPCONFIG WHERE key ='CheckSend' and a.PO like ??)
如果不行就先查询,然后取出数据,分割后循环like判断
...全文
2283打赏收藏
oracle,某个栏位用,隔开做判断
一个栏位维护多个值用,隔开,用 like来匹配,可以用sql写出来吗 SELECT count(0) FROM LMDN a WHERE EXISTS (SELECT * FROM APPCONFIG WHERE key ='CheckSend' and a.PO like ??) 如果不行就先查询,然后取出数据,分割后循环like判断