title: Copy values from one table to another with 'where' condition
body: <p>I want to copy values from songDetails table to playlistDetails table.</p>
  
  <p>here is my code : </p>
  
  <pre><code>public void transferData(String name) {
  
      SQLiteDatabase db = this.getWritableDatabase();
      String selectQuery = "INSERT INTO "+ TABLE_CURRENTLIST + " SELECT * FROM " + TABLE_DATA + " WHERE " + KEY_ALBUMNAME+ " = " + name + "";
      db.execSQL(selectQuery);
  }
  </code></pre>
  
  <p>While executing this code, it throws this exception</p>
  
  <pre><code>01-31 01:29:49.426: E/AndroidRuntime(3102): android.database.sqlite.SQLiteException: no such column: unknown (code 1): , while compiling: INSERT INTO PlayListDetails SELECT * FROM songDetails WHERE albumName = unknown
  </code></pre>
  
  <p>the value of 'name' variable is correct. And i want to copy only the rows which have the albumName as unknown.
  I'm struggled with this. Please help me.</p>