SQL Query to transfer threads from one forumID to another?

[aupurbo]

Guys, I want to transfer all threads from forumID1 to forumID2. Is there any SQL Query that I can execute to do that? Its huge in number, and kinda pain to move them by selecting them one after another...

Thanks on credit.

[Lats]

Back up first!!...

UPDATE
 thread
SET
 forumid = 2
WHERE
 forumid = 1

You'll need to update counters / forum information after running the query.

[aupurbo]

Back up first!!...

UPDATE
 thread
SET
 forumid = 2
WHERE
 forumid = 1

You'll need to update counters / forum information after running the query.

AH!! Thanks mate. What e great relief!!!