Alter mysql field

[mpadc]

Hello
Something simply for you all im not sure the code

In table "user" there is a field called "receivebulletin_type" at the moment its value on most of the users is set to 0
i want to run an sql query so the value of all the users is set to 1
how do i do this please :$

[Paul M]

update user set receivebulletin_type = 1 ;

[mpadc]

yaay thanks paul :)

[ragtek]

you have to run: UPDATE user set receivebulletin_type = 1
per phpmysql or in the acp

if you have a tableprefix you have to put it before the user

edit: paul was faster