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

WHERE clouse

2003-01-08 Thread Dejan Milenkovic
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 ...

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 ...