(mysql.info.gz) Operator Precedence
Info Catalog
(mysql.info.gz) Non-typed Operators
(mysql.info.gz) Non-typed Operators
(mysql.info.gz) Parentheses
12.1.1 Operator Precedence
--------------------------
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
The precedence shown for `NOT' is as of MySQL 5.0.2. For earlier
versions, or from 5.0.2 on if the `HIGH_NOT_PRECEDENCE' SQL mode is
enabled, the precedence of `NOT' is the same as that of the `!'
operator. Server SQL mode.
Info Catalog
(mysql.info.gz) Non-typed Operators
(mysql.info.gz) Non-typed Operators
(mysql.info.gz) Parentheses
automatically generated byinfo2html