select id,name,weight from t_weight where CHARINDEX(',01,02,03,04,05,06,07,08,09,10,11,12,',weight)<>0
你先用: select CHARINDEX(weight,',01,02,03,04,05,06,07,08,09,10,11,12,') from t_weight where CHARINDEX(weight,',01,02,03,04,05,06,07,08,09,10,11,12,')<>0 看看结果是几,如果是0就是没合适数据,不是0再看看代码吧
不包含weight
所以没有任何值
select CHARINDEX(weight,',01,02,03,04,05,06,07,08,09,10,11,12,')
from t_weight
where CHARINDEX(weight,',01,02,03,04,05,06,07,08,09,10,11,12,')<>0
看看结果是几,如果是0就是没合适数据,不是0再看看代码吧
select pub_id,CHARINDEX(pub_id,'000736000112532110877465432')
from titles
where CHARINDEX(pub_id,'000736000112532110877465432')<>0
结果:
1389 0
1389 0
0736 3
1389 0
0877 18
0877 18
0877 18
1389 0
1389 0
1389 0
0877 18
0736 3
0736 3
0736 3
0736 3
0877 18
0877 18
0877 18