From: Gregory W Burnham <gburnham@sfu.ca>
To: pierre@desertmoon.com
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Quickie
Date: Mon, 8 Feb 1999 13:56:09 -0800
Message-ID: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca> (raw)
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@desertmoon.com>
To: <pgsql-sql@postgreSQL.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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: gburnham@sfu.ca, pierre@desertmoon.com
Subject: Re: [SQL] Quickie
In-Reply-To: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca>
References: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox