How can I move all polls from one forum to another in vBulletin or PhPMyAdmin?

[RS25.com]

I currently have a ton of polls in my "General" forum and have created a new "Polls" forum. I thought I would just go into the /Admin and move them, but the options to move posts does not have one for polls.

So, is there any way to do this? I'm fine with hacking code (a little) or using PhpMyAdmin and some raw SQL.

I am on the current version of vBulletin.

[Jake Bunce]

This query should work. Backup first:

UPDATE thread SET forumid = X WHERE pollid > 0 AND open != 10

Where X is the forumid of your Polls forum. After running this query you will need to update your various counters:

Admin CP -> Import & Maintenance -> Update Counters

[Neutral Singh]

Will this query still work on 3.8.0? I want to move all Polls into a newly created forum dedicated to polls.

Thanks

[Neutral Singh]

Can anybody help with the query, please?