title: Can these two SQL statements be made into one? Changing multiple indices with two constraints
body: <p>I have a form that users can use to edit data in my database.  The database is structured like this:</p>
  
  <p><img src="https://i.stack.imgur.com/oqxoK.png" alt="table"></p>
  
  <p>If a user wants to edit both a FAVE_COLOR and a FAVE_FOOD, how would I go about doing that in my SQL statement? I can think of this, but is there a way to do this in one statement?</p>
  
  <pre><code>string sql1 = "UPDATE MYTABLE " +
                "SET PROP_VALUE = '" + form["color"] + "' " +
                "WHERE ID = " + form["id"] + " " +
                "AND PROP_NAME = 'FAVE_COLOR'"
  
  string sql2 = "UPDATE MYTABLE " +
                "SET PROP_VALUE = '" + form["food"] + "' " +
                "WHERE ID = " + form["id"] + " " +
                "AND PROP_NAME = 'FAVE_FOOD'"
  </code></pre>