Operators and expressions

Comparisons, conditions, CASE, CAST and comments.

Name	What it does
Operators	Comparison, logical, arithmetic and concatenation operators, and their precedence.
LIKE	Match text against a pattern with % and _ wildcards.
IN	Test whether a value is one of a list, or among a subquery's values.
BETWEEN	Test whether a value lies in a range, ends included.
IS NULL	Test whether a value is missing; IS TRUE and IS FALSE test booleans.
EXISTS	Test whether a subquery returns any row.
CASE	Choose a value by testing conditions in order.
CAST	Convert a value to another type.
Comments	Text in a statement that the engine ignores.