like in sql without case sensitive code example
Example: sql like case sensitive
-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john
-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john