Mysql operator priority

The following list shows the order of operator priorities from low to high. Operators in the same row have the same priority.

Operator priority
The following list shows the order of operator priority from low to high. Operators in the same row have the same priority.

: =

|, OR, XOR

&, AND

NOT

BETWEEN, CASE, WHEN, THEN, ELSE

=, <=>, >=, >,<=, <, <> ,! =, IS, LIKE, REGEXP, IN

|

&

<,>

-, +

*,/, DIV, %, MOD

^

-(Minus one dollar ),~ (Bitwise reversal)

!

BINARY, COLLATE

NOTE: If HIGH_NOT_PRECEDENCE SQL mode is activated, the priority of NOT is the same as that of! The operators are the same. See section 5.3.2 "SQL SERVER mode ".

12.1.2. parentheses
(...)

Use arc to specify the Operation Sequence of the expression, for example:

Mysql> SELECT 1 + 2*3;
-> 7
Mysql> SELECT (1 + 2) * 3;
-> 9