Re: WHERE clouse

2003-01-09 Thread Andrea Forghieri
All the test I've made shows that the first query is faster . I can't believe my eyes. Andrea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: WHERE clouse

2003-01-08 Thread Adolfo Bello
On Wed, 2003-01-08 at 15:30, Dejan Milenkovic wrote: > Hi, > Is there a difference in speed between these two querys: > SELECT whatever, somethin_else FROM table1 WHERE 1 AND ( > table1.whatever='value' OR ) > SELECT whatever, somethin_else FROM table1 WHERE table1.whatever='value' > OR ..