title: MySQL: return updated rows
body: <p>I am trying to combine these two queries in twisted python:</p>
  
  <pre><code>SELECT * FROM table WHERE group_id = 1013 and time &gt; 100;
  </code></pre>
  
  <p>and:</p>
  
  <pre><code>UPDATE table SET time = 0 WHERE group_id = 1013 and time &gt; 100
  </code></pre>
  
  <p>into a single query. Is it possible to do so?</p>
  
  <p>I tried putting the SELECT in a sub query, but I don't think the whole query returns me what I want.</p>
  
  <p>Is there a way to do this? (even better, without a sub query)
  Or do I just have to stick with two queries?</p>
  
  <p>Thank You,</p>
  
  <p>Quan</p>