title: how to modify an item's value in a SQLite?
body: <p>Supposing I have this sqlite database structure:</p>
  
  <pre><code> ID     PRODUCT_NAME     AVAILABILITY 
  
    1       foo            0
    2       bar            1
    3       baz            0
    4       faz            1
  </code></pre>
  
  <p>How cand I modify the value of the <code>AVAILABILITY</code> fom 1 -> 0 where <code>PRODUCT_NAME = 'bar'</code> ?
  Something like this,
  Pseudocod:</p>
  
  <pre><code>db.execSQL( "UPDATE TABLE" + Table_name + "MODIFY" + availability + "=" + 0 + "WHERE" +  product_name + "like ? " + 'bar');
  </code></pre>
  
  <p>I assume that I also have to drop and recreate table using onCreate() and onUpgrade() methods, right?
  Some code will be highly appreciated.</p>