http://www.postgresqltutorial.com/postgresql-like/ PostgreSQL provides the ILIKE operator that acts like the LIKE operator. -- In addition, the ILIKE operator matches value case-insensitively. SELECT first_name, last_name FROM customer WHERE first_name ILIKE 'BAR%';
