2009/3/29 Oscar <ro4...@gmail.com>: > Hi all- > > I want to know what the difference between IN and OR is under the hood. > > select * from dummy_table where id in (2, 3, 4, 5, 6, 7); > > select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or > id=7;
I've have thought once the query is compiled, they are the same. What might cause a difference in performance is doing id > 2 and id <= 7. Test it on a large dataset and let us know :) -- Blog: http://pookey.co.uk/blog Follow me on twitter: http://twitter.com/ipchristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org