3.1 Special operators

BETWEEN

• operator provides an alternative way to determine if a value is between two other values. The operator is written value BETWEEN minValue AND maxValue and is equivalent to:

• value >= minValue AND value <= maxValue. // These are both inclusive. Includes both minValue and maxValue.

LIKE

• when used in a WHERE clause, matches text against a pattern using the two wildcard characters % and _.

• % matches any number of characters. e.g. LIKE 'L%t' matches "Lt", "Lot", "Lift", and "Lol cat".

• _ matches exactly one character. e.g. LIKE 'L_t' matches "Lot" and "Lit" but not "Lt" and "Loot".

ORDER BY

• clause orders selected rows by one or more columns in ascending (alphabetic or increasing) order. Low -> High. e.g. A -> a.

• DESC reverses order High -> Low.

DESC

keyword with the ORDER BY clause orders rows in descending order.