From: | "Mitch Vincent" <mvincent(at)cablespeed(dot)com> |
---|---|
To: | "Michael Gay" <mike7411(at)earthlink(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Case sensitivity issue |
Date: | 2001-09-14 20:13:31 |
Message-ID: | 001301c13d59$ba31bcd0$1e51000a@mitch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT * FROM apples WHERE lower(color) LIKE '%red%';
Make sure that what ever 'red' might be is always lower case (you can pass
it through lower() too, of course)..
-Mitch
----- Original Message -----
From: "Michael Gay" <mike7411(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, September 10, 2001 12:02 AM
Subject: [GENERAL] Case sensitivity issue
> If I am doing a command such as
>
> select * from Apples where color like '%red%';
>
> how do I make it case insensitive?
>
> Thanks.
>
> mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Schnabel | 2001-09-14 20:14:55 | Re: need help |
Previous Message | Steve Wolfe | 2001-09-14 20:09:49 | Re: How to make a REALLY FAST db server? |