title: MySQL update case help
body: <p>Can anybody tell me how to fix this query?</p>
  
  <pre><code>update ae44
  set Price = Case
  when ID = 'AT259793380' then '500'
  when ID = 'AT271729590' then '600'
  when ID = 'AT275981020' then '700'
  end case
  </code></pre>
  
  <p>I just want to mass update listing price based on ID by matching up ID.</p>