Postgres Pro
Downloads
Home   >   mailing lists

Re: update part of a column record - Mailing list pgsql-admin

From Aras Angelo
Subject Re: update part of a column record
Date
Msg-id 5136d4130909080954o2c71346sc7e9a5af25d75d84@mail.gmail.com
Whole thread Raw
In response to update part of a column record  (Marc Fromm <Marc.Fromm@wwu.edu>)
List pgsql-admin
Tree view
UPDATE table SET column=REPLACE(column,'@cc.edu','@somethingelse.com');

change "column" to field name respectively.

On Tue, Sep 8, 2009 at 10:46 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:

I have a column that contains user email addresses. I need to update all email address in the column that end with @cc.edu to @ss.edu and retain the information (the user name) that exists before the @ symbol. Is there an update query that can edit part of a column record?

 

Marc

 


pgsql-admin by date:

Previous
From: Marc Fromm
Date:
Subject: update part of a column record
Next
From: Kevin Kempter
Date:
Subject: partitioning and set statistics