WordPress MU

2.9.2

I've moved my wordpress files to wordpress mu and everything works like a charm.

My only problem is the photo urls that came with the original tables are absolute photo urls and therefore link back to the old wp location.

Is there a way to change this easily? To new absolute urls or to relative urls.

I've searched for an answer and could not find it, if this has been asked already sorry and can someone point me to the answer.

Thanks a bunch
SJ

Gotta admit that I would just use Notepad on a Windows PC to do a search and replace through the xml file before importing. :)

If you;ve already imported the file, you should be able to search and replace with a SQL command.

I;m very tired right now but I believe this would work:

http://www.joegrossberg.com/archives/000933.html

Thanks it worked great
Sorry I didn't google my question first I just searched here.

also for others I had to use the format
"/folder1/folder2/folder3/" instead of "folder1/folder2/folder3"

It kept giving me errors until I made that small change.

also another reference is http://www.calinstan.com/2010/04/mysql-find-replace-query-wordpress/

The format taken from the above web site is
update wp_posts set post_content= replace (post_content, “www.example.com”, “www.myblog.com”);

Sj