Re: Intro to indexing?

2009-07-29 Thread william drescher
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

Properly Use Replace Command

2009-07-29 Thread Carlos Williams
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

RE: Properly Use Replace Command

2009-07-29 Thread Nathan Sullivan
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:

Re: Properly Use Replace Command

2009-07-29 Thread Carlos Williams
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