How can I mass activate users awaiting for email confirmation directly in database?

Somehow, the database shows 153. The group shows 110 and when I mass sent emails to that group, 92 went out.

So I would like to make a query into useractivation and activate everybody and start from scratch.

run this query:

UPDATE set usergroupid=2 WHERE usergroupid=3

that will change everybody who's waiting for email confimation and set them as a regular user.

oh no... it doesn't work! I get an error in phpmyadmin:

MySQL said: You have an error in your SQL syntax near 'set usergroupid=2 WHERE usergroupid=3' at line 1

when I type that in!!

OK... that is because it needs to read

UPDATE **user**, which is left out in the post above. :)

doh! how can i be so careless....

UPDATE user SET usergroupid=2 WHERE usergroupid=3