title: Updating multiple rows in a MySQL table using CASE WHEN THEN statement - not working
body: <p>this is driving me nuts so any help would be greatly appreciated. </p>
  
  <p>I'm trying to increment points totals in specific rows of a table by a number given by the user. I've got some PHP which generates this statement dynamically based on a form input:</p>
  
  <pre><code>UPDATE users SET points = CASE userID 
      WHEN 11 THEN (points + 1) 
      WHEN 16 THEN (points + 6) 
      WHEN 7 THEN (points + 7) 
      WHEN 10 THEN (points + 10) 
  WHERE userID IN (11,16,7,10) 
  END
  </code></pre>
  
  <p>I don't want to store the values in a PHP variable due to the issue of multiple accessors.</p>