100分跪求一个高难SQL文的写法。

Question

SELECT * FROM MItem WHERE SameItem LIKE '1,%' 
UNION ALL
SELECT * FROM MItem WHERE SameItem LIKE '%,1,%'
UNION ALL
SELECT * FROM MItem WHERE SameItem LIKE '%,1';

Answer 1

SELECT * FROM MItem WHERE ','||SameItem||',' LIKE '%,1,%'

Answer 2

select * from MItem where SameItem LIKE '1,%' or SameItem LIKE '%,1,%' or SameItem LIKE '%,1';

Answer 3

回复人： biliky()的方法不错.

Answer 4

回复人： biliky()的方法不错.

Answer 5

select * from MItem where instrb(','||SameItem||',',',1,')>0;

Answer 6

select tt.idd,tt.counts from (
       select idd,length(idd)-length(replace(idd,'1','')) counts from table
)tt
where tt.counts=1

Answer 7

09:17:18 LY>select * from t1;PRODUCTCOD PRICEDATE       PRICE  PRE_PRICE                                     
---------- ---------- ---------- ----------                                     
185644                                                                          
11432                                                                           
1665                                                                            
234                                                                             
11                                                                              
1                                                                               
12341243                                                                        
ae1143                                                                          
153                                                                             
11111                                                                           
111                                                                             PRODUCTCOD PRICEDATE       PRICE  PRE_PRICE                                     
---------- ---------- ---------- ----------                                     
11                                                                              
123                                                                             
190fed                                                                          
1790                                                                            
150                                                                             
1165                                                                            
1533                                                                            已选择18行。已用时间:  00: 00: 00.0009:17:55 LY>select tt.PRODUCTCODE , count from
09:18:47   2  (select PRODUCTCODE,length(PRODUCTCODE)-length(replace(PRODUCTCODE,'1','')) count from t1) tt
09:18:47   3  where tt.count=1;PRODUCTCOD      COUNT                                                           
---------- ----------                                                           
185644              1                                                           
1665                1                                                           
153                 1                                                           
123                 1                                                           
190fed              1                                                           
1790                1                                                           
150                 1                                                           
1533                1                                                           已选择8行。已用时间:  00: 00: 00.00

Answer 8

SELECT * FROM MItem WHERE ','||SameItem||',' LIKE '%,1,%';

Answer 9

biliky()的方法是不对的。这样的话12,11,14也能检索出来。
多谢myy()、qiyousyc(沈阳棋友)  、andy_KAO，结贴！