how can i change word in the all topics

[mr.ehab]

hello,

How can i change word or link to another in the all topics in my forum

[Marco van Herwaarden]

Is this a 1 time change?

[mr.ehab]

no the word i want to change it, in the all topics in my forum

example

i want to change the link yahoo.com to vbulletin.com with out edit the topics one by one

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

is there any away or plugin to make it ?

[Marco van Herwaarden]

You could run a query to manually change all the posts.

[mr.ehab]

yes, but it's around 2000 topics , is there any easy away ?

[Marco van Herwaarden]

You can do all posts in a single manual query:

[sql]UPDATE post
SET pagetext = REPLACE(pagetext, 'OLDTEXT', 'NEWTEXT')
WHERE pagetext LIKE '%OLDTEXT%';[/sql]

PS Always create a backup vefore running manual update queries.