By czeky on

Hi,

is there a way (sure it is) how to change all image urls?

I have url like "http://www.othersite.com/images/" - because for a development I'm linking images from the original site and for the final version I need to change url into "/files/images/"

I'm using TinyMCE, Drupal 5

I prefer MySQL way, but don't know syntax for sql query like UPDATE xxx SET zzz WHERE yyy, basicaly find "xxx" and change it to "yyy"

Many thanx for a help

Zdenek

⋅ Categories: Drupal 5.x

Comments

two2the8’s picture

two2the8 commented

I think you can use 'update' and 'replace' together to achieve this:

UPDATE some_table
SET some_column=(
REPLACE (some_column,
'images',
'files/images'));

Of course, backup your DB before you try this. See http://dev.mysql.com/doc/refman/4.1/en/update.html & http://dev.mysql.com/doc/refman/4.1/en/replace.html for more info.

czeky’s picture

czeky commented

I did a search in sql for "http://www.othersite.com/images/" and it didnt find a thing, anyway searching for "othersite.com/images" is the same - not found, do You know, where (in which table) is html content of the node (edited in TinyMCE) saved?

thanx