title: How Can I Detemine What a MySQL IF() Condition Did on UPDATE Without Re-SELECTING the Table
body: <p>I have the following MySQL Statement in place:</p>
  
  <pre><code>mysql_query('
      UPDATE states
      SET
          '.$_REQUEST['name'].' = '.$_REQUEST['name'].' + 1,
          limitReached = IF('.$_REQUEST['name'].' = "30", "High", IF('.$_REQUEST['name'].' = "15", "Low", NULL))
      WHERE region = "' . $_REQUEST['region'] . '"
      LIMIT 1
  ');
  </code></pre>
  
  <p>I wish to take certain actions depending on what happens to the limitReached column. But I prefer to not re-read the table with a subsequent query select.</p>
  
  <p>Is it possible to have MySQL report what it did in my IF() condition?</p>
  
  <p>[It's sort of like the rows affected result, but more so, for a column affected situation]</p>