Re: select .. like ignore case - Mailing list 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.gil@audax.com.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