Which query would be faster?

[Duskwalker]

Hi everyone, I just wanted to know which would be faster...

$psel = mysql_query("select * from players where page='Exploring Sewer' and sew_x=$x and sew_y=$y and recent=1 and id!=$stat[id] limit 1");

or

$psel = mysql_query("select * from players where id!=$stat[id] and page='Exploring Sewer' and sew_x=$x and sew_y=$y and recent=1  limit 1");

Recent=1 just means that its someone who has logged in today so it doesnt go through the list of 2k members, and rather just 200 members. Does that make a difference at all?

And also the second was has the "where ~ and ~ and ~~" in order like it is in the database table. I wasnt sure if it goes faster like that or not.

Any comments are appreciated.

Regards

[devinemke]

there would be no difference between those two queries. the order of things in the WHERE clause makes no difference (someone jump on me if i'm wrong here).

[mhalloran]

Yeah, I don't think that MySQL filters the data in the same order in the filters are presented.

Also, When you execute the query in the terminal, it reports the execution time to you. I'm not sure if the same goes for phpMyAdmin.