title: Get Updated Value in MySQL instead of affected rows
body: <p>I've been trying to find an answer to this question, but haven't found any definitive "yes" or "no" in all my research.</p>
  
  <p>I'm running a simple MySQL query like this:</p>
  
  <pre><code> UPDATE item SET `score`=`score`+1 WHERE `id`=1
  </code></pre>
  
  <p>Is there a way for that query to return the updated value, instead of the number of rows affected?  Just as a reference, I'm doing this in PHP, so the actual code looks like:</p>
  
  <pre><code> $sql = "UPDATE item SET `score`=`score`+1 WHERE `id`=1";
   $new_value = mysql_query($sql); 
   //Unfortunately this does not return the new value
  </code></pre>
  
  <p>I know I could do a second query and just SELECT the value, but I'm trying to cut down on queries as much as possible.  Is there a way?</p>