Re: SELECT question

From: Devrim GUNDUZ <devrim(at)tr(dot)net>
To: Brian Avis <brian(dot)avis(at)searhc(dot)org>
Cc: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: SELECT question
Date: 2003-01-30 23:24:09
Message-ID: 1043969051.963.13.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Fri, 2003-01-31 at 01:11, Brian Avis wrote:
> I want to run a SELECT on a text field and match any of the following.
>
> brian
> Brian
> BRIAN
>
> Or any other combination. How do I tell SQL to ignore case when doing
> a SELECT?

SELECT * FROM table WHERE column ILIKE 'brian%';

should work.

Best regards,
--
Devrim GUNDUZ
www.gunduz.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch 2003-01-31 00:00:38 Security Question
Previous Message Brian Avis 2003-01-30 23:21:15 Re: SELECT question