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

[vbresults]

Originally Posted by Lynne

Well, as the error says, there is no forumid column in the post table. You would need to join with the thread table (post.threadid = thread.threadid) in order to get the forumid (thread.forumid).

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