title: sql: how to select all records with field set to 0 and set the value of that field to one
body: <p>Is this possible in one SQL statement?
  I pointer to a nice SQL tutorial on the subject is also appreciated.
  I know I can use a command like <code>SELECT * FROM MYTAB WHERE MYFIELD = 0</code>
  and then use a server script to go through the result and <code>UPDATE MYFIELD</code>
   of the result rows.</p>