title: On field UPDATE if value is already SET, SET it to something else?
body: <p>I know I can easily do this with a few lines of PHP but I was hoping there was a method in MYSQL to do this; I would think there is but I am not having any luck finding it.</p>
  
  <p>Basically I want to do this:</p>
  
  <pre><code>UPDATE fieldName SET status='1'
  if status='1', SET status='2'
  </code></pre>
  
  <p>So that second line is obviously not real code, but that is what I want to do.  UPDATE a field to a value, and if that field already equals that value update it to a different value.</p>