Optimization - in which order are processed the 'AND' operands?

[Emiliano Supemo]

I have a simple question.
I made a request like this on table with millions of rows :

Request 1 :

SELECT myTable.id
FROM myTable, otherTable
WHERE myTable.id =otherTable.id_cp
AND myTable.type_base =2

Everything is indexed.
I know that in this table with millions of rows, a very few of them have type_base =2.

What will be the best, request 1 or request 2 (where the order of the AND operands are inverted)? :

Request 2:

SELECT myTable.id
FROM myTable, otherTable
WHERE myTable.type_base =2
AND myTable.id =otherTable.id_cp


Does mySql process from left to right or right to left?
Does mysql process the other comparison if the first one is false?


Regards,


(Sorry for my poor english)