title: how to use like clause with db.query(....) in SQLite
body: <p>hi i am new to android and got stuck in a problem</p>
  
  <p>i have a table of two fields songname and songhits in my database .Now i want to get  all songs starting with a string say MATCH_STR sorted by songhits in a list.I know the sql query but i dont know how to execute in my android app.pls help me with an example or correct code.</p>
  
  <p>my code : </p>
  
  <pre><code>  Cursor c = myDB.query(MY_DATABASE_TABLE, "songname","songname like %"+MATCH_STR+"%" , null, null,"SongHit", null);
      if (c != null) 
      {
  
           c.moveToFirst(); 
           int SongNameColumn = c.getColumnIndex("SongName"); 
           if (c.isFirst()) 
           { 
                    i = 0; 
  
                    do { 
                             i++; 
                              String SongName = c.getString(SongNameColumn); 
  
                              // Add current Entry to results. 
                             results.add(SongName); 
                        } while (c.moveToNext()); 
            }
  } 
  </code></pre>