The LIKE predicate determines whether the right expression string matches the left expression string.
LIKE can only be applied to STRING values. If any input expression is NULL, NULL is returned.
The following wildcards can be used in the right pattern expression:
- %: Matches any string with zero or more characters.
- _: Matches exactly one character.
Wildcards can be escaped with a backslash (
\_). If no wildcards are contained, leading and trailing
% wildcards are assumed, and comparison is not case sensitive.