Global Search and Replace

[wedgey]

I'm not having much luck with the forum search, maybe someone could help -

When I first installed vBulletin I used a subdomain as my forums URL. Now that the forum has "grown up" I've given it TDL URL but I have some problems that I didn't anticipate.

Existing posts to threads within the forum reference the old subdomain and result in a 404 error.

Is there a way within vBulletin to do a global search and replace? All I want to do is to replace the sub-domain with the new TDL URL. My first choice would be let vBulletin handle the SQL tables - I'm a total rookie.

Is there an easy solution to this problem? If not anyone want to offer a bid to perform the search and replace then upload the DB via SSH?

Thanks!

[wedgey]

OK, instead of asking how-to, may I ask how much? Anyone want to tackle the global search and replace of one URL for another in a SQL DB?

Please PM with quote. Thanks