DAMINK
04-23-2012, 08:19 AM
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.
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.