The match operator must be used with wildcard characters. The string to match must be surrounded by single quote marks.
|
Characters |
Meaning |
Example |
|---|---|---|
|
* |
Zero or more characters |
lastname match ‘sm*’ |
|
? |
One character |
lastname match ‘sm?th’ |