关于select in的问题
我写了如下的两条SQL语句：
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1, ID2')
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2, ID1')
按理说，两条语句执行结果应该是一样的，但是结果不一样
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1, ID2')的结果和
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID1')一样
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2, ID1')的结果和
SELECT count(*) FROM Topics WHERE AND SectionID in ('ID2')一样
不太明白为什么，请大家解释一下
[解决办法]
寫法應該是:
SELECT count(*) FROM Topics WHERE AND SectionID in ( 'ID1', 'ID2')
