Case sensitivity issue - Mailing list pgsql-general

If I am doing a command such as

select * from Apples where color like '%red%';

how do I make it case insensitive?

Thanks.

mike