title: MySQL Update Multiple Rows to Increment Values Not Working
body: <p>I am trying to update multiple rows on one table using MySQL. I have found that this is possible but I am trying to increment the value of the comments column by a given amount, however trying to increment it by 1 actually increments it by 3.</p>
  
  <pre><code>$increment = 1;
  ('UPDATE articles
  SET comments = CASE
  WHEN article_id in(1, 2) THEN comments + ' . $increment . '
  END');
  </code></pre>
  
  <p>Any ideas?
  Thanks,
  Matt</p>