28,390
社区成员
发帖
与我相关
我的任务
分享
classid =“,” + classid +","
SELECT id,title FROM Sd_Info where classid in (,1,105,106,107,11,120,121,122,123,126,96,131,18,23,30,4,39,128,143,144,145,17,34,12,95,132,21,19,130,137,) and ID=668
刚刚说错了。在classid前后加上逗号,在in后面的字符串前后也加上逗号
SELECT id,title FROM Sd_Info where classid like %,3,% and classid in (,1,105,106,107,11,120,121,122,123,126,96,131,18,23,30,4,39,128,143,144,145,17,34,12,95,132,21,19,130,137,) and ID=668
3前面和后面加个,字符串也加个
SELECT id,title FROM Sd_Info where classid like %3% and classid in (1,105,106,107,11,120,121,122,123,126,96,131,18,23,30,4,39,128,143,144,145,17,34,12,95,132,21,19,130,137) and ID=668