title: return the updated value after running the update query in mysql
body: <p>Im sorry if the question seems odd and stupid but I need to know if it is possible or what.</p>
  
  <p>So
  I have the following query that updates the status of a request record in the requests table. </p>
  
  <pre><code>$updateQ = "UPDATE requests SET status = status+1 WHERE rid = '$rid'";
  if($this-&gt;db-&gt;query($updateQ))
      return $this-&gt;db-&gt;select('status')-&gt;from('requests')-&gt;where('rid', $rid)-&gt;get()-&gt;row('status');
  </code></pre>
  
  <p>I wonder if I can get the value of the updated <strong>status</strong> field right after executing the query without running another select query.</p>