SELECT *
FROM bank.district
WHERE A3 LIKE 'north%';
% -- Wildcard Character / can represent any Character
like -- it's a Keyword to search for a specific pattern

SELECT *
FROM bank.order
WHERE k_symbol REGEXP '^s';
REGEXP -- Keyword to search for a specific pattern
^ -- find a pattern from the beginning

SELECT *
FROM bank.order
WHERE k_symbol REGEXP 's[ijk][p][o]$';
$ -- this sign means the end of our values
[] -- gorup of possible characters

SELECT *
FROM bank.district
WHERE A2 REGEXP 'cesk[ey]';
-- searching for all the names with cesk and ending up with the 
-- words with the letters 'ey'
 
SELECT *
FROM bank.district
WHERE A2 REGEXP 'cesk[e-r]';
-- searching for the letters between e and r

"<https://regexlearn.com/cheatsheet>"
-- website with all the characters

"<https://regexlearn.com/playground>"
-- to try diferents patterns