Re: select .. like ignore case

From: Marcin Gil <marcin(dot)gil(at)audax(dot)com(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: select .. like ignore case
Date: 2003-12-19 09:59:25
Message-ID: 3FE2CBFD.6050609@audax.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

MaFa wrote:

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

simple, eh?
--
Marcin Gil :: marcin(dot)gil(at)audax(dot)com(dot)pl
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-12-19 15:26:51 Re: Upgrading from v7.1.3 to v7.4
Previous Message Marcin Gil 2003-12-19 09:30:03 Re: select .. like ignore case