Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with SELECT and string - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: Help with SELECT and string
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMEMNDLAA.nickf@ontko.com
Whole thread Raw
In response to Help with SELECT and string  (Tomasz Misterka <tomasz@hieroglif.com.pl>)
List pgsql-admin
Tree view 

> Now when I'm searching database for word "chris" i can't find word
> "Chris" - how the SELECT should looks like?


select name from nametable where lower(name) = 'chris';

or

select name from nametable where upper(name) = 'CHRIS';

-Nick

PS: I'd suggest taking general SQL questions like this to the pgsql-general
list.

---------------------------------------------------------------------
Nick Fankhauser

Business:
nickf@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop  - Court records at your fingertips - http://www.doxpop.com/

Personal:
nick@fankhausers.com   http://www.fankhausers.com

pgsql-admin by date:

Previous
From: Tomasz Misterka
Date:
Subject: Help with SELECT and string
Next
From: "Michael B. Babakov"
Date:
Subject: How to make 'tail -f' in PostgreSQL?