Mysql Update where value = AnyNumber

Is it possible to use UPDATE and set the WHERE to only UPDATE where the value = ANYNUMBER?

For Example:

UPDATE user_accounts set password_reset = 1 where user_ID = NumericValue?

If it's a User_ID, and the column type is INT, then all rows in the table should be numeric?

If some rows are null for this field, then you can use:

UPDATE user_accounts SET password_reset = 1 WHERE user_id IS NOT NULL;

Your correct, just couldn't see further than the end of my nose for a moment or to!

you can also leave the WHERE bit off to have it update all records unconditionally