Question: what is the difference between like and ilike?
Answer: The keyword ILIKE can be used instead of LIKE to make the match case insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension. The operator ~~ is equivalent to LIKE , and ~~* corresponds to ILIKE . ... All of these operators are PostgreSQL-specific.