SQL wildcards

SQL wildcards

1. Wildcards The wildcard uses the * symbol, and is used in place of any number of unknown characters. For example, the following code searches for all programmes with the letter i in the title:

2. % A substitute for zero or more characters _ A substitute for a single character [charlist] Sets and ranges of characters to match [^charlist] or [!charlist] Matches only a character NOT specified within the brackets