MySQL where clause with the AND and OR | MySQL tutorial
This tutorial picked up where the previous tutorial left off and taught you how to combine WHERE clauses with the AND and OR operators. You also learned how to explicitly manage the order of
evaluation, and how to use the IN and NOT operators.
and
http://sqlfiddle.com/#!9/c8121/4
or
http://sqlfiddle.com/#!9/c8121/7
wrong compinig order
http://sqlfiddle.com/#!9/c8121/1
right compinig order
http://sqlfiddle.com/#!9/c8121/2
