title: MYSQL UPDATE SET on the Same Column but with multiple WHERE Clauses
body: <p>With MYSQL I'm using this query:</p>
  
  <pre><code>UPDATE CustomerDetails_COPY
  SET Category_ID = 10
  WHERE Category_ID = 2
  </code></pre>
  
  <p>Thats fine but I'd like to ad 15+ more <code>SET/WHERE</code> to it like:</p>
  
  <pre><code>UPDATE CustomerDetails_COPY
  SET Category_ID = 9  WHERE Category_ID = 3
  SET Category_ID = 12 WHERE Category_ID = 4
  SET Category_ID = 11 WHERE Category_ID = 5
  .....
  </code></pre>
  
  <p>How would I add to this?</p>
  
  <p>EDIT:</p>
  
  <p>As Per Hunters Suggestion:</p>
  
  <pre><code>UPDATE CustomerDetails_COPY
      SET Category_ID = CASE Category_ID
          WHEN 2 THEN 10 
          WHEN 3 THEN 9
          WHEN 4 THEN 12
          WHEN 5 THEN 11
      END
  WHERE Category_ID IN (2,3,4,5)
  </code></pre>
  
  <p>This works Great! Thanks</p>