On September 12th, 2006 Scott Noyes (not verified) says:
The manual also says about IN ():
"If all values are constants, they are evaluated according to the type of expr and sorted. The search for the item then is done using a binary search. This means IN is very quick if the IN value list consists entirely of constants."
(http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html)
I would have thought that meant there is a considerable difference between IN () and =OR=. Does it not?
The manual also says about
The manual also says about IN ():
"If all values are constants, they are evaluated according to the type of expr and sorted. The search for the item then is done using a binary search. This means IN is very quick if the IN value list consists entirely of constants."
(http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html)
I would have thought that meant there is a considerable difference between IN () and =OR=. Does it not?