title: How can I update a single (or multiple, but not all) columns in an SQLiteDatabase?
body: <p>I use a <code>SQLitDatabase</code> for my project, which I normally update by:</p>
  
  <ul>
  <li>Getting all the values one row contains (let's say v1, v2 and v3)</li>
  <li>Putting all the values back, and replacing the ones I need to be updated.  </li>
  </ul>
  
  <p>Example:</p>
  
  <p>I want to update <code>v2</code>.</p>
  
  <pre><code>ContentValues values = new ContentValues();
      values.put(v1_COLUMN, v1);        // Old value, gotten earlier
      values.put(v2_COLUMN, v2_new);    // New value, calculated earlier
      values.put(v3_COLUMN, v3);        // Old value, gotten earlier
  db.update(TABLE_name, values, "_id=?", new String[]{id});  
  </code></pre>
  
  <p>I use this method, even if I only have to update 1 column (keep in mind some of my tables have more then 3 columns).</p>
  
  <p>How can I update only the column that actually needs updating?</p>