Alter mysql field
 

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 :$

update user set receivebulletin_type = 1 ;

yaay thanks paul :)

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