The precedence of operators determines the order of evaluation. To override this order and group terms explicity, use parentheses. Lets see the example below:

Select 6+2-4*1, (6+2-4)*1;

Operator are shown bellow from lowest to the highest precedence. Operators shown together on a line have the same precedence. Lets take a look:

:=
||, OR, XOR
&&, AND
NOT
BETWEEN, CASE, WHEN, THEN, ELSE
=, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN
|
&
<<, >>
-, +
*, /, DIV, %, MOD
^
- (unary minus), ~ (unary bit inversion)
!
BINARY, COLLATE

Note: If the HIGH_NOT_PRECEDENCE SQL mode is enabled, the precedence of NOT is the same as that of the ! operator.