Wildcards
Wildcards in SQL
There are 4 different possibilities for wildcards in SQL:
% any string consisting of no, one or many characters, e.g. Pinus % will find anything like Pinus, Pinus sylvestris, Pinus strobus etc.
* any string consisting of no, one or many characters, e.g. Pinus * will find anything like Pinus, Pinus sylvestris, Pinus strobus etc.
_ a single character, e.g. Pinus s**_lvestris will find Pinus sylvestris and Pinus si**lvestris etc.
[] ** any character out of a given range like [abcde] or [a-e], e.g. Pinus s[iy]**lvestris will find Pinus sylvestris and Pinus silvestris.
[^] any character not in a given range like [^abcde] or [^a-e], e.g. Pinus s**[^i]**lvestris will find Pinus sylvestris but not Pinus silvestris.