muhammad subair wrote:
On Mon, Jul 27, 2009 at 9:25 PM, Ken D'Ambrosio k...@jots.org wrote:
Hey, all. I'm trying to get indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been
I know this seems very basic and I checked Google before posting but
it appears that many of the manuals / guides online reference
something a bit more extreme than what I am looking for.
I am searching a table called 'identities' and in that table there is
a column called 'email'. Some people
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
Regards,
Nathan
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Wednesday, July 29, 2009 1:58 PM
To:
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivannsulli...@cappex.com wrote:
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
That worked perfect!
UPDATE identities
- SET