![]() |
How do I remove a certain word from posts?
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. |
It's best to ask these sort of questions in the importing forums at http://www.vbulletin.com
|
[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. |
It works. Thanks very much Marco.
|
All times are GMT. The time now is 01:41 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|