How do I validate all the topics in vBulletin 4.1.x using sql. I have query but it only works for 1 i need to validate for more than 1000!!!

Here is the code that works with one

UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` =1;

I think If I am able to change that threadid =1 to something like autoincremeant it should work out
MR.KiDO Reviewed by MR.KiDO on . Validate all topics How do I validate all the topics in vBulletin 4.1.x using sql. I have query but it only works for 1 i need to validate for more than 1000!!! Here is the code that works with one UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` =1; I think If I am able to change that threadid =1 to something like autoincremeant it should work out Rating: 5