title: SQL - WHERE clause on each SET command in UPDATE?
body: <p>I'm trying to create an SQL query in PHP to update a table.
  Is it possible to have a different <code>WHERE</code> clause for each affected row?</p>
  
  <p>eg something like:</p>
  
  <pre><code>UPDATE table 
  SET val=X WHERE someproperty = 1,
  SET val=Y WHERE someproperty = 2
  </code></pre>
  
  <p>etc?</p>
  
  <p>Any help appreciated.  Thanks</p>