Mysql Update where value = AnyNumber

[danIT]

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?

[webman]

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;

[danIT]

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

[Arcath]

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