Postgres Pro
Downloads
Home   >   mailing lists

Re: select .. like ignore case - Mailing list pgsql-novice

From MaFa
Subject Re: select .. like ignore case
Date
Msg-id freemail.20031119100642.89465@fm3.freemail.hu
Whole thread Raw
In response to select .. like ignore case  (Marcin Gil <marcin.gil@audax.com.pl>)
Responses Re: select .. like ignore case
Re: select .. like ignore case
List pgsql-novice
Tree view 
> 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

pgsql-novice by date:

Previous
From: Marcin Gil
Date:
Subject: select .. like ignore case
Next
From: Patrice Durosay
Date:
Subject: Re: Can't create lock file /tmp/.s.PGSQL.5432.lock