Re: select .. like ignore case

From: MaFa <mafalista(at)freemail(dot)hu>
To: Marcin Gil <marcin(dot)gil(at)audax(dot)com(dot)pl>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: select .. like ignore case
Date: 2003-12-19 09:06:42
Message-ID: freemail.20031119100642.89465@fm3.freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Is there a way to issue select .. like to ignore letter case?
**For example:
select * from customers where upper(name) like '%JOHN%'

> Or do I have to use full text indexing?
**Full-text indexing is a whole other thing...

Bye:
MaFa

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrice Durosay 2003-12-19 09:23:12 Re: Can't create lock file /tmp/.s.PGSQL.5432.lock
Previous Message Marcin Gil 2003-12-19 08:52:38 select .. like ignore case