XF 2.0 Query for designating threads in forum ID with tag ID?

[ibrian]

Is there a query I can use in phpmyadmin to add a specific tag ID to all threads within a specific forum ID, please?

For example, in my HP Lovecraft subforum (node ID 100) I'd like to add the tag "HP Lovecraft" (tag ID 200) to every thread already posted there.

I could do it manually, but I have thousands of threads to tag across different boards, so I'd be grateful on any pointers on a quick and dirty way to do this, presumably using queries in phpmyadmin.

 

[ibrian]

I managed to figure out a SQL query for changing signature preferences for members, but I'm struggling with this one for the moment.

Is one even possible? Or am I going to have to simply tag them all manually?