[SOLVED] Query/where (performance question)

[Locked]

Would the query bellow be better than: mysql_query("select name from table where userid=1");

or

mysql_query("select name from table where userid=1" and password='password' and username='me');

 

Question: Does the more detail you give in the where statement better/faster? (Names/passwords etc would be stored in sessions when they login)

[wsantos]

If those fields are indexed then yes...otherwise no.

[Locked]

Thanks and yes they are index's