title: How to update a field based on its current value in MySQL?
body: <p>Is it possible to get the current value of a field, use it as a variable in a calculation, then update the field based on the result?</p>
  
  <p>For example the record with the ID "1" in table1 has a value of "2"</p>
  
  <pre><code>SELECT table1
  WHERE ID = "1"
  SET RESULT to CurrentID
  RESULT = CurrentID + 1;
  </code></pre>