Ok this is something I've wondered about for a while but I've never come across the answer. Does MySQL process WHERE clauses in the order they are given in a select/update string or not?
I ask because if they are processed in the order given in a SELECT string then this will impact efficiency, therefore it would be useful to know so I can improve my scipts.


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks