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/showthread.php?t=284933&highlight=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 (http://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 (http://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!!!