title: Multiple set and where clauses in Update query in mysql
body: <p>I don't think this is possible as I couldn't find anything but I thought I would check on here in case I am not searching for the correct thing. </p>
  
  <p>I have a settings table in my database which has two columns. The first column is the setting name and the second column is the value. </p>
  
  <p>I need to update all of these at the same time. I wanted to see if there was a way to update these values at the same time one query like the following</p>
  
  <pre><code>UPDATE table SET col1='setting name' WHERE col2='1 value' AND SET col1='another name' WHERE col2='another value';
  </code></pre>
  
  <p>I know the above isn't a correct SQL format but this is the sort of thing that I would like to do so was wondering if there was another way that this can be done instead of having to perform separate SQL queries for each setting I want to update. </p>
  
  <p>Thanks for your help.</p>