1-- Case insensitive
2SELECT * FROM my_table WHERE upper(my_column) LIKE 'SEARCHED %'; -- starts with
3SELECT * FROM my_table WHERE upper(my_column) LIKE '% SEARCHED'; -- ends with
4SELECT * FROM my_table WHERE upper(my_column) LIKE '%SEARCHED%'; -- contains