Editing members post count?

[dcpaq2xx]

Group,

Is it possible after a member has accumulated post count to go in and return them to "Zero" or edit it to show a different number?

I have disabled view of post count to all, and allowed post count to accumulate, but if for some reason later down the road I should decide that I dont want post count to accumulate and always show "Zero" posts, is it possible for me to set everyone back to "zero" permenately and if so how do i go about doing it, and can it be done as a mass command?

Thanks

Doug

P.S. I was told this over on VB.Com but this isnt what Im looking for. I want something thats going to change the post counts permenately not temporary with cache as Jake mentions. Anyone know of a way to accomplish this easily?

Originally Posted by Jake Bunce

This query will set everyone to 0 posts:

UPDATE user
SET posts = 0

But this only changes the cached value. If you ever rebuild user post counts then the true values will be restored.