SQL QUERY to disable forums from What's New?

[aiman.h.kallaf]

I have a lot of forums and i want to disable the ( Include threads from this forum when users click "What's New?" ) from all of them , so that i can go and activate the few forums that i want manually
can anyone please make a sql query to do so

 

[Jake Bunce]

UPDATE xf_forum
SET find_new = 0

 

[aiman.h.kallaf]

thank you very much
it would be great if someone went all over your post regarding queries and post them in one topic , it would be a great library for future reference
if you have time you can make a complete topic about it and use it as reference , you'll get the chance to update the topic or recourse whenever a new question rinses