Changing a thread's rating via SQL execution

[Polo]

How would I reset a thread's rating to 0 executing a sql query?

any help would be really appreciated thanks :)

[Guy G]

UPDATE threadrate SET vote=0 WHERE threadid=x;


Not entirely sure, wait for some more replies.

[Polo]

ok I will thanks :)

[Polo]

tried it say it affected 40 rows but the rating still in the thread :( any tips?

[tnguy3n]

should be this query:
UPDATE thread SET votetotal = '0' WHERE threadid = 'X';