title: Multiple Where Updates in one Query - Efficient Structure
body: <p>I'm attempting to update a large set of rows using typical <code>update</code> <code>where</code> syntax.</p>
  
  <p>To keep things consolodated, I had put together this query, but it is not working (failing at the first parenthesis)</p>
  
  <pre><code>UPDATE product_options 
  SET 
      (object_id=14,option_key='size_small',option_name='Size Small',option_description='This is the small size...',option_price=2.50),
      (object_id=14,option_key='size_medium',option_name='Size Medium',option_description='This is the medium size...',option_price=5.50),
      (object_id=14,option_key='size_large',option_name='Size Large',option_description='This is the large size...',option_price=10.50),
      (object_id=14,option_key='size_really_big',option_name='Size Really Big',option_description='This is the really big size...',option_price=20.50)
  
  WHERE (option_id=1), (option_id=2), (option_id=3), (option_id=4)
  </code></pre>
  
  <p>Each <code>SET</code> statement has a corresponding <code>WHERE</code> statement. So what is going wrong here?</p>
  
  <hr>
  
  <h2>EDIT:</h2>
  
  <p>Based on answer provided, this was the complete query which ended up working:</p>
  
  <pre><code>UPDATE `product_options` SET
  
  `object_id` = 14,
  
  `option_key` = CASE
  WHEN `option_id`='1' THEN 'size_small'
  WHEN `option_id`='2' THEN 'size_medium'
  WHEN `option_id`='3' THEN 'size_large'
  ELSE `option_key` END,
  
  `option_name` = CASE
  WHEN `option_id`='1' THEN 'Small'
  WHEN `option_id`='2' THEN 'Medium'
  WHEN `option_id`='3' THEN 'Larger'
  ELSE `option_name` END,
  
  `option_price` = CASE
  WHEN `option_id`='1' THEN 5.50
  WHEN `option_id`='2' THEN 10.00
  WHEN `option_id`='3' THEN 21
  ELSE `option_price` END
  
  WHERE `option_id`='1' OR `option_id`='2' OR `option_id`='3'
  </code></pre>