WHERE match_expression [NOT] LIKE pattern
Wildcard symbols
Symbol Description
% Matches any string of zero or more characters.
_ Matches any single character.
[ ] Matches a single character listed within the brackets.
[ - ] Matches a single character within the given range.
[ ^ ] Matches a single character not listed after the caret.