Operator precedences are shown in the following list, from lowest precedence to the highest.
Operators that are shown together on a line have the same precedence.
:=
||, OR, XOR
&&, AND
NOT
BETWEEN, CASE, WHEN, THEN, ELSE
=, , =, , , !=, IS, LIKE, REGEXP, IN
|
&
-, +
*, /, DIV, %, MOD
^
- (unary minus), ~ (unary bit inversion)
!
BINARY, COLLATE