How do I remove a certain word from posts?

[PageUp]

I migrated from phpbb and I have lots of wrong links in posts, that point to the non-existant viewtopic.php page (same thing as showthread.php in vB).

I would like to remove all those links from posts. What SQL queries do I need to run?

Any help would be greatly appreciated.

[Tony G]

It's best to ask these sort of questions in the importing forums at http://www.vbulletin.com

[Marco van Herwaarden]

[sql]UPDATE post SET pagetext = REPLACE (pagetext,'old-string','new-string') WHERE pagetext LIKE '%old-string%';[/sql]
Just edit the above and replace 'old-string' (twice) with the link you want to replace, and 'new-string' with the new link.

[PageUp]

It works. Thanks very much Marco.