how to use like clause with db.query(....) in SQLite
<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>
