1-- Postgresql case insensitive:
2SELECT * FROM people WHERE name ILIKE 'JOHN'
3-- John
4-- JOHN
5-- john
1SELECT DISTINCT COL_NAME FROM myTable WHERE UPPER(COL_NAME) LIKE UPPER('%PriceOrder%')
2# or
3SELECT DISTINCT COL_NAME FROM myTable WHERE LOWER(COL_NAME) LIKE LOWER('%PriceOrder%')
4