title: How to update Sqlite database for only one column using WHERE clause in android
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/9798473/sqlite-in-android-how-to-update-a-specific-row">SQLite in Android How to update a specific row</a>  </p>
  </blockquote>
  
  
  
  <p>Is it possible to update database for one column using where statment
  And this was my table structure and i need to update "messagestatus" column using "id".</p>
  
  <pre><code>db.execSQL("CREATE TABLE IF NOT EXISTS autosms(id INTEGER PRIMARY KEY AUTOINCREMENT ,phonenumber VARCHAR(15) ,message VARCHAR(5000) , year VARCHAR(10) , month VARCHAR(10) , date VARCHAR(10) , hour VARCHAR(10) , minute VARCHAR(10) , messagestatus VARCHAR(10))");
  </code></pre>
  
  <p>I tried with this, but with out Success theres an  warning "No such column Send"</p>
  
  <pre><code>public void update(int id)
  {
          String s = "Send";
          db= SQLiteDatabase.openDatabase("data/data/com.example.schduled_messages/SMS_Schdule_Sample.db", null, SQLiteDatabase.CREATE_IF_NECESSARY);
          db.execSQL("UPDATE autosms SET messagestatus="+s+" WHERE id="+id+""); 
      }
  </code></pre>
  
  <p>Thanks in Advance..</p>