Re: Case sensitivity issue - Mailing list pgsql-general

Use: ILIKE

Michael Gay wrote:

> If I am doing a command such as
>
> select * from Apples where color like '%red%';
>
> how do I make it case insensitive?
>
> Thanks.
>
> mike