String Formatting#
Old Style#
Syntax |
Description |
Regex Equivalent |
|---|---|---|
|
Match zero or one wildcard |
|
|
Repeat previous character |
|
Predicate#
A predicate either in the WHERE or HAVING clause can use strings.
Old Style
<WHERE|HAVING> <column> LIKE '<like clause>'
Standard Regular Expression
<WHERE|HAVING> <column> ~ '<regex>'