Re: Case sensitivity issue

From: Szabo Zoltan <col(at)econet(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Case sensitivity issue
Date: 2001-09-10 11:16:51
Message-ID: 3B9CA123.D02DAED9@econet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szabo Zoltan 2001-09-10 11:21:37 Re: enumeration datatype in postgresql?
Previous Message Daniel ?erud 2001-09-10 10:10:10 Re: "user"