[Database]Operators

Arithmetic Operators

+，－，×，÷

Comparison Operators

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

BETWEEN，IN，IS NULL

Logical Operators

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

String Operators

LIKE，||

Operators precendence

parentheses > comparison > AND > OR

() > 比较 > and > or

Arithmetic > Comparison > Logical

 

Strings comparison

digits < lowercase letters < uppercase letters.