From: | Matthew Rice <matt(at)starnix(dot)com> |
---|---|
To: | Szabo Zoltan <col(at)econet(dot)hu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Case sensitivity issue |
Date: | 2001-09-14 22:41:52 |
Message-ID: | lv8zfhs8cv.fsf@sol.starnix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Szabo Zoltan <col(at)econet(dot)hu> writes:
> Use: ILIKE
>
> > If I am doing a command such as
> > select * from Apples where color like '%red%';
> > how do I make it case insensitive?
I was trying to solve a similar problem where I wanted an exact match to work
in PostgreSQL and MySQL and ended up with:
lower(Field) = lower('string')
Is there another way that works on both?
--
matthew rice <matt(at)starnix(dot)com> starnix inc.
tollfree: 1-87-pro-linux thornhill, ontario, canada
http://www.starnix.com professional linux services & products
From | Date | Subject | |
---|---|---|---|
Next Message | Erol Öz | 2001-09-14 22:43:57 | Ynt: pg_dump error - LOCALIZATION PROBLEM |
Previous Message | Erol Öz | 2001-09-14 22:41:43 | Ynt: get certain # of recs |