title: SQL Update And Select In A Single Query
body: <p>Is there a way in SQL (MySQL) to increment a value, and also return the value in a single query. I am trying to ovoid doing two queries like the following:</p>
  
  <p>QUERY 1</p>
  
  <pre><code>UPDATE my_table SET my_col = (my_col + 1) WHERE something = something_else;
  </code></pre>
  
  <p>QUERY 2</p>
  
  <pre><code>SELECT my_col FROM my_table WHERE something = something_else;
  </code></pre>
  
  <p>Thanks.</p>