我想知道以下两种方法在性能方面是否有什么不同
SELECT ... FROM ... WHERE someFIELD IN(1,2,3,4)
SELECT ... FROM ... WHERE someFIELD between 0 AND 5
SELECT ... FROM ... WHERE someFIELD = 1 OR someFIELD = 2 OR someFIELD = 3 ...
还是MySQL会像编译器优化代码一样优化SQL?
编辑:由于 comments 中所述的原因,将AND
改为OR
.