title: How UPDATE and SELECT at the same time
body: <p>I need to update some rows of the tables and then display these rows. Is there a way to do this with one single query and avoid this 2 query ? :</p>
  
  <pre><code>UPDATE table SET foo=1 WHERE boo=2
  
  SELECT * from table WHERE ( foo=1 ) AND ( boo=2 )
  </code></pre>