Query to toggle a Boolean value in MySQL [duplicate]

UPDATE mytbl
   SET field = !field
 WHERE id = 42

Where 42 is the id of the record, field is the name of the Boolean field and mytbl is the table name.