Which mysql construct is faster?
- by Olaseni
SELECT ..WHERE COL IN(A,B) or SELECT ... WHERE (COL = A or COL = B)
I'm trying to find out what are the differences between the two constructs? Would there be significant performance gains either way if utilized on resultsets that are nearing the 1 million mark?