SQL query subscription

[DAMINK]

I want to run a query to change all users subscription status from where they are not subscribed to where they are. Not an ideal thing to want to do but i dont have a huge member base and its not to spam.
Now in not real clear on the correct way to do this.
I am assuming something like this will work?

UPDATE user
SET autosubscribe = '1'
WHERE autosubscribe = '-1'

Thanks if anyone can assist me here.