From: | Andrew Chambers <andychambers2002(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Finding and replacing text within records |
Date: | 2006-01-18 00:41:52 |
Message-ID: | 20060118004152.GA25166@yapgi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 17:09 Tue 17 Jan , Lynna Landstreet wrote:
> Hello,
>
> I'm wondering if there is a way in SQL to find and replace a specific string
> within various database records, the way you might across a text document.
> Not to replace the entire value of the fields in which the string is found,
> but just that specific string.
http://www.postgresql.org/docs/8.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP
[snip]
> So is there a way to search out all occurrences of, say,
> the string "testsite.mydomain.com" within a specific column and change
> it to "www.theirdomain.com" wherever it's found?
regexp_replace(field, 'testsite\.mydomain\.com', 'www\.theirdomain\.com' [,flags])
Regards,
Andy
From | Date | Subject | |
---|---|---|---|
Next Message | s anwar | 2006-01-18 01:23:56 | Re: alter table set tablespace over nfs getting stuck |
Previous Message | Tom Lane | 2006-01-17 22:53:52 | Re: alter table set tablespace over nfs getting stuck |