Wildcard query information
Below find the example of Wildcard syntax and usecases.
| Symbol | Description | Example |
|---|---|---|
| * | Matches zero or more characters. It can be used as the first or last character in the character string. | wh* finds wh, what, white, and why |
| ? | Matches any single alphabetic character. | b?ll finds ball, bell, and bill |
| [ ] | Matches any single character within the brackets. | b[ae]ll finds ball and bell but not bill |
| ! | Matches any character not in the brackets. | b[!ae]ll finds bill and bull but not ball or bell |
| - | Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A). | b[a-c]d finds bad, bbd, and bcd |
| # | Matches any single numeric character. | 1#3 finds 103, 113, and 123 |