Changing Forum URL and hard code links

[paintballer.ie]

There are loads of threads altready on changing the url of a board - great info there,here is one of the best: http://www.vbulletin.com/forum/showt...=domain+change

My question is that a lot of my posts have hard links to images embedded in them e.g. www.example.com/forum/images/1.jpg

I will be restructuring my site so the images folder is now www.exapmple.com/community/images/1.jpg

Can I download the database, edit it dreamweaver or other and search and replace 'forum' for 'community' or is this needed or is there a better way.

Thanks

[Lats]

Run this SQL query in phpmyadmin, or the ACP...

UPDATE 
 post 
SET 
 pagetext = REPLACE(pagetext,'www.example.com/forum','www.example.com/community')

[BizAdventure]

Run this SQL query in phpmyadmin, or the ACP...

UPDATE 
 post 
SET 
 pagetext = REPLACE(pagetext,'www.example.com/forum','www.example.com/community')

THANK YOU!!! This worked like magic!

Question...can we do the same thing but with the signatures?

[Lats]

Sure, try this...

UPDATE
    usertextfield
SET
    signature = REPLACE(signature,'olddomain.com','newdomain.com')

[BizAdventure]

Sure, try this...

UPDATE
    usertextfield
SET
    signature = REPLACE(signature,'olddomain.com','newdomain.com')

This rawked, thank you so much!!!