title: Select rows from database then change a value in a column
body: <p>I'm using the following query:</p>
  
  <pre><code>select id,link,size from files where status='-1' ORDER BY id DESC LIMIT 10
  </code></pre>
  
  <p>then I want to change the 'status' column values of the selected rows to -2, is it possible to combine the 'select' and 'update' functions in the same query so that I don't have to query the database again?</p>