Reset Post Counters?

[Bald Bouncer]

Is there a way to reset all members postcounts back to 0?

thanks

[amykhar]

update user set posts=0;

[Admin]

Note that when updating post counters they will all get their real post count again!