Find and replace query

[decipher442]

Hi,

I was wondering is there was some sort of an sql query I could run through the admin panel to find and replace test on the site...

In short I merged another forum into mine and not I would like to replace the "old-forum.com" text in all the posts, hopefully by running a query instead of opening each and every post to edit the text to my current domain.

making any sense?

--------------- Added [DATE]1266007312[/DATE] at [TIME]1266007312[/TIME] ---------------

anyone know the solution to this?

[decipher442]

I assume that there is no solution to this..?

[Dylanblitz]

I don't think there is a way to do it inside of the forums.

If it was me I'd run a replace command through phpmyadmin or export, replace and import.

[Andy]

Admin CP -> Maintenance -> Execute SQL Query

UPDATE post SET pagetext = REPLACE(pagetext, 'old-forum.com', 'new-forum.com')

Be sure to do a backup first just in case you make a mistake.