Re: Properly Use Replace Command

2009-07-29 Thread Carlos Williams
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan 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 email=replace(email, 'mail.'

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: my

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 hav

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 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 RTFM'ing, but h