For an exact string match, use LIKE.
To match any amount of characters, use the symbol ‘%’.
To match one (and only one) character, use the character ‘_’.
To match any pattern, use both ‘%’ and ‘_’.
To detect strings that don’t fit a pattern, use NOT.
Case-insensitive pattern matching is achieved by combining LOWER (or          UPPER) with LIKE.