In SQL we can use conditions that implement limited pattern matching.
Certain patterns can be specified using the symbol % to replace 0 or more char-
acters, and the underscore to replace exactly one character. As mentioned ear-
lier, SQL is generally not case-sensitive; however, comparisons involving strings
are case-sensitive. Thus, “Jerry” and “JERRY” are distinct strings, and ’Jerry’
¿ ’JERRY’. The comparison is realized using the operator like.