On Wed, Aug 20, 2003 at 03:08:59PM -0500, Tom O'Neill (MySQL User) wrote: > Is there any difference in speed between the following select statements? > > SELECT yada,yda FROM test WHERE id IN(1,2,3) > > OR > > SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
Often times, no. But it's best to bencmkark in your environment to be sure. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 958,389,289 queries (566/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
