mysql command question - need to change data in a table

[ludachris]

There is a field in the user database that I want to change for all users. It's a simple change - going from "0" to "1". How would you write a SQL query to change the data for all users from "0" to "1" in that field?

[Paul M]

UPDATE user SET field = 1;