Expressions and Strings
Arithmetic expressions, string pattern matching.
AS and = are two ways to name fields in result.
LIKE is used for string matching.
- `_’ stands for any one character and `%’ stands for 0 or more arbitrary characters.
SELECT S.age, age1=S.age-5, 2*S.age AS age2
WHERE S.sname LIKE ‘B_%B’