From: | "Gregory W Burnham" <gburnham(at)sfu(dot)ca> |
---|---|
To: | <pierre(at)desertmoon(dot)com>, <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] Quickie |
Date: | 1999-02-08 21:56:09 |
Message-ID: | 003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
select User_Email from <whatever your table name is> where User_Email ~*
'fubar';
I think, I haven't tried it yet.
Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, B.C.
(604) 291 3615 ph
(604) 291 5679 fx
----- Original Message -----
From: <pierre(at)desertmoon(dot)com>
To: <pgsql-sql(at)postgreSQL(dot)org>
Sent: Monday, February 08, 1999 1:57 PM
Subject: [SQL] Quickie
>Hi all...here is a quickie for ya:
>
>Given:
>User_Email|User_ID
>-------------------
>fubar | 1
>barfu | 2
>snafu | 3
>Fubar | 4
>
>What query could I use to return ONLY 'fubar' and 'Fubar'? Would I do a
self
>join? The problem is that I'd forgotten to force everything to lowercase
upon
>insertion, and now I need to clean out the uppercase records and/or convert
them
>to lowercase.
>
>Ideas?
>
>-=pierre
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | pierre | 1999-02-08 21:57:22 | Quickie |
Previous Message | Gregory Holston | 1999-02-08 21:53:50 | HAVING |