title: Android: select query in android database
body: <p>I need to get the values of children column corresponding to key column as in the image. What would be the select statement for it in android sqlite.</p>
  
  <p>Thanks</p>
  
  <p><img src="https://i.stack.imgur.com/bXtAD.jpg" alt="enter image description here"></p>
  
  <p>I am using following code for it:</p>
  
  <pre><code> public Cursor fetchChildren(String KEY_){
              Cursor c = db.rawQuery("SELECT children FROM " + DATABASE_TABLE_NAVIGATION
                      + " WHERE key =" + KEY_+ "", null);
                         return c;
  </code></pre>
  
  <p>But it is giving me exception:</p>
  
  <pre><code>android.database.sqlite.SQLiteException: no such column: home: , while compiling: SELECT children FROM navigation WHERE key =home
  
             }
  </code></pre>