like case insensitive
SELECT * FROM table_name WHERE UPPER(col_name) LIKE '%SEARCHED%';
SELECT * FROM table_name WHERE col_name LIKE '%Searched%'; -- Case sensitive
SYMBOL DESCRIPTION (SQL) EXAMPLE
% zero or more characters bl% 'bl, black, blue, blob'
_ a single character h_t 'hot, hat, hit'
[] any single character within brackets h[oa]t 'hot, hat', but NOT 'hit'
^ any character not in the brackets h[^oa]t 'hit', but NOT 'hot, hat'
- a range of characters [a-b]t 'cat, cbt'