title: How to update column only is its empty in sqlite?
body: <p>I am using below query to update the column. Now what I want that I want to update these columns only when it is empty or null. How can I achieve this ?</p>
  
  <pre><code> db.execSQL("UPDATE FieldTestDataTemp SET 
             Image1 = '" + f10.image1 + "', 
             Image2 = '" + f10.image2 + "', 
             Image3 = '" + f10.image3 + "', 
             Image4 = '" + f10.image4 + "', 
             Image5 = '" + f10.image5 + "',
             starRating = '" + starRating1 + "' ");
  </code></pre>