title: SQL update multiple rows on specific ID's
body: <p>I am trying to write a query to update several rows of my SQL table at once.  Below is the code I have tried, and it doesn't appear to be proper SQL as it doesn't work. Is there a way to accomplish this is one query?</p>
  
  <pre><code>$query = "UPDATE table_names
            SET Name='Bob' WHERE ID=7 
            SET Name='Mike' WHERE ID=34"
  </code></pre>