title: SQL update multiple rows with different values where they match a value from a list
body: <p>So perhaps the title is a little confusing. If you can suggest better wording for that please let me know and i'll update.</p>
  
  <p>Here's the issue. I've got a table with many thousands of rows and i need to update a few thousand of those many to store latest email data. </p>
  
  <p>For example:</p>
  
  <p>OldEmail@1.com => NewEmail@1.com</p>
  
  <p>OldEmail@2.com => NewEmail@2.com</p>
  
  <p>I've got a list of old emails ('OldEmail@1.com','OldEmail@2.com') and a list of the new ('NewEmail@1.com','NewEmail@2.com'). The HOPE was was to sort of do it simply with something like </p>
  
  <pre><code>UPDATE Table 
  SET Email = ('NewEmail@1.com','NewEmail@2.com')
  WHERE Email = ('OldEmail@1.com','OldEmail@2.com')
  </code></pre>
  
  <p>I hope that makes sense. Any questions just ask. Thanks!</p>