title: MySQL UPDATE on SELECT
body: <p>In MySQL, is it possible to update the selected records on the same query?</p>
  
  <p>For eg., If the query</p>
  
  <pre><code> SELECT * 
     FROM `table`
    WHERE field = "value"
    LIMIT 0,2
  </code></pre>
  
  <p>Return two rows, then on the same query, i need to increment the table's <code>count</code> field by 1. Is it possible?</p>