Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: MitchDate: 2003-01-31 00:00:38
Subject: Security Question
Previous:From: Brian AvisDate: 2003-01-30 23:21:15
Subject: Re: SELECT question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group