SQL query to find/repalce post text in a specific forum

[anjaan7979]

Originally Posted by Lancerforhire

UPDATE post
	SET pagetext = REPLACE(pagetext, 'oldtext', 'newtext')
		WHERE (SELECT forumid FROM thread WHERE thread.threadid = post.threadid) = 435

That worked like a charm! Thanks a lot.

Some questions:

1. What if I want to replace multiple words?
2. For multiple Child forums, is it possible to select a parent forum?

This will cut down a lot of time for me.

Thanks again.