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 1250732711 at 1250732711 ---------------

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:

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

PS Always create a backup vefore running manual update queries.