title: mySQL UPDATE value based on SELECT value of value +1 Incrementing column value
body: <p>The Query:</p>
  
  <pre><code>UPDATE nominees SET votes = ( SELECT votes
  FROM nominees
  WHERE ID =1 ) +1
  </code></pre>
  
  <p>The Error:</p>
  
  <blockquote>
    <p>You can't specify target table 'nominees' for update in FROM</p>
  </blockquote>
  
  <p>Not sure whats wrong there based on the error, this is the first time im tryin to incriment a column inline i guess you can call it. So I am obvioulsy doing something wrong but dont know how to fix it.</p>