title: Update multiple rows in 1 column in MySQL
body: <p>What is the proper query for updating multiple rows in MySQL at the same time? </p>
  
  <p>I am only updating 1 column:</p>
  
  <pre><code>UPDATE example_table SET variable1 = 12 WHERE id=1;
  UPDATE example_table SET variable1 = 42 WHERE id=2;
  UPDATE example_table SET variable1 = 32 WHERE id=3;
  UPDATE example_table SET variable1 = 51 WHERE id=4;
  </code></pre>
  
  <p>This seems like it may be inefficient, or if it is the most efficient query let me know :)</p>