search and replace

Поиск
Список
Период
Сортировка
От Gallamine
Тема search and replace
Дата
Msg-id 007301c2a2e2$7614d2e0$b6e9fea9@anywhere.ncsu.edu
обсуждение исходный текст
Ответы Re: search and replace  (Josh Berkus <josh@agliodbs.com>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Chad Thompson"
Дата:
Сообщение: Re: SQL help
Следующее
От: "Gallamine"
Дата:
Сообщение: formatting current_timestamp