Help with a simple mySQL query

[Njörd Eriksson]

I would like to reset the reputation points of all members to 10 (what would hopefully keep all reputation comments given so far.) I'm pretty confident that this could be done by running a single query (ALTER TABLE or something)?

Can some advanced mySQLer help me with the syntax please?

[legolas]

update user set reputation=10;

That will reset reputation for all users. You might want to qualify that with "... where usergroupid=x" where x is the typical user group number.

[Njörd Eriksson]

Thank you. :)