Help with SQL query, need to reset colum pmunread from <prefix>user
 

Original post at vb.com but thinking this is proberly a better place..

Been haveing alot of problems with a old mod i removed along with upgradeing to vb4.

It was sending pms to users with arcade stuff, and such.. all removed now,
uninstalled succesfully. but now while uninstalling if left PMunreads with alot of people
howewer the message is gone, so unable to reset it, so when logging in it always says
you have x number of private messages..

We agreed to simply reset the count to 0..

So i went and found the table and colum i need to change to 0 for all.
but i need help formulating a query..

table is
<prefix>user

Colum is
pmunread

so i was thinking something like..

usually i would add "where" after new value, but im not sure if leaving it out like above
it would just update ALL records as wanted

havent tryed anything, wanted to hear first.. (no rush)