Operator Precedence:

    Operators are used to operate with two operands. Wide collection of Operators are available in MySQL. The operator precedences are shown below in the table.

Highest Precedence	:=
1	||, OR, XOR
2	&&, AND
3	BETWEEN, CASE, WHEN, THEN, ELSE
4	=, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN
5	|
6	&
7	<<, >>
8	-, +
9	*, /, DIV, %, MOD
10	^
11	- (unary minus), ~ (unary bit inversion)
12	!, NOT
Lowest	BINARY, COLLATE

   If a statement contains paranthesis, then the operations inside the paranthesis are performed first. These operators will be explained in the following sections.