From: | "Gallamine" <iam(at)gallamine(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | search and replace |
Date: | 2002-12-13 20:01:35 |
Message-ID: | 007301c2a2e2$7614d2e0$b6e9fea9@anywhere.ncsu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have a database with text in it (articles) and in the article I have <img>
tags for pictures in HTML. I want to go through the DB and replace the urls
of the images. How would I go about doing that? I want to grab all the text
from the articles table and replace the string "http://dopey.lulupress.com"
with "http://faramir/".
Any hints?
-William
[ GoRobotics.net | RobotGeeks.com | RobotDirectory.org ]
Amateur robotics for the masses. Enter the world of robotics
------------------------------------------------------------
"...God maintains a delicate balance between keeping his
existence sufficiently evident so people will know He's there
and yet hiding his presence enough so that people who
want to choose to ignore him can do it "
- J.P. Moreland PH.D.
----------------------------------------------------------------
Carpe Aeternum - Seize Eternity
From | Date | Subject | |
---|---|---|---|
Next Message | Gallamine | 2002-12-13 20:03:58 | formatting current_timestamp |
Previous Message | Chad Thompson | 2002-12-13 01:08:18 | Re: SQL help |