mass update users whoose certain field is not empty

[spaceb]

help me please, I want to mass update only thoose users whoose "game" field is not empty.
How can i do it?? :ermm:

[nexialys]

UPDATE vb_user set thefield='fieldcontent' WHERE game='';

this will update the field "thefield" when the field "game" is empty ...

[spaceb]

Thank you very much nexialys

[spaceb]

ohh its wrong mate, its updated me all the users whoose "game" field is empty, i asked only thoose whoose game table is not empty. :surprised:

[Velocd]

UPDATE user
SET field = 'content'
WHERE game != ''

[spaceb]

thank you Velocd