Arithmetic Operators

+，－，×，÷

Comparison Operators

＝，<>，!=，>，<，>=，<=

LIKE，BETWEEN，IN，IS NULL

Logical Operators

AND，OR，NOT[IN | LIKE| BETWEEN | NULL]

String Operators

LIKE，||

Operators precendence

parentheses > comparison > AND > OR

() > 比较 > and > or

Arithmetic > Comparison > Logical

Strings comparison

digits < lowercase letters < uppercase letters.

[Database]Operators