title: MySQL: Updating all rows setting a field to 0, but setting one row's field to 1
body: <p>Is there an efficient way to update a selection of rows' field to 0, but set One of these rows to 1 based on an ID.</p>
  
  <p>Basically, I have multiple objects in a database, and I want to toggle between which one is "inuse", so the query will set one of the rows (by id) to inuse=1 and the others to inuse=0.</p>
  
  <p>Thanks :)</p>