这个MYSQL语句怎么查不出正确的结果?
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ( '2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11' ) ORDER BY date_added DESC
是不是IN语句限制了in子句参数的数目?而且不能全部查出来,不知道怎么回事?
问题点数：5、回复次数：4Top
1 楼zhys9（OoP.plorer）回复于 2006-12-02 13:58:34 得分 2
改一下
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ( 2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESCTop
2 楼danis_cn（宇宙鸟）回复于 2006-12-02 15:11:57 得分 1
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ('2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESCTop
3 楼iasky（iasky）回复于 2006-12-02 21:44:50 得分 1
不要那个单引号Top
4 楼yueliangdao0608（(深圳PHPER.MSN:yueliangdao0608@gmail.com）回复于 2006-12-03 08:41:51 得分 1
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ('2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESCTop
