mysql WHERE condition execution

[s5jz]

Hello all,

I have 2 columns and I search rows with two conditions.

SELECT * FROM table WHERE A = '$a' AND B = '$b'

How can I make mysql search columns with A condition first and after that within these condition B.

Thanks,

[LordShryku]

You already are...

Or do you mean "if A fails, then search B"?

[s5jz]

I would like to make sure, that mysql first finds raws matching condition A, and after that within this raws condition B raws, witch are actually raws with A and B condition. I need to do this, for faster searching.

This is just a simple example. I have something like A AND (B OR C). A are numbers and mutch easier to search with than with B or C witch is text.

I would like to know, how mysql search works.
Does mysql check conditions from left to the right, checking the first one than checking the second one within results...?

How can I tell mysql how to search?