[RESOLVED] changing the value of int in mysql database

[LesSjo]

Is there a way to change the value of an int (from 0 to 1) stored in the database in one field for all records at once? 😕

[Kudose]

Yes.

i.e.

UPDATE table SET field=1 WHERE field=0

Alternatively, if you want to affect all records

UPDATE table SET field=1

[LesSjo]

Thanks,
That was a whole lot quicker than updating 8000 records 1 at a time.