Thanks. I finally figure it out. All the suggestion works, even what I used previously. It's just that if I have the loading done in onCreate method, the list is empty.
On Feb 18, 12:18 am, loty <lev.pert...@gmail.com> wrote: > This works for me > String sFilter = KEY_DATA + "LIKE'%" + queryString + "%'"; > return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_DATA, > KEY_LAST_MODIFIED}, sFilter, null, null, null, null); > > On Feb 16, 6:26 am, hc <honch...@gmail.com> wrote: > > > I want to do a query equivalent to this > > > "SELECT * FROM search_table WHERE keywordLIKE'%abc%'"; > > > How can I do this? I have tried out different methods using rawQuery > > but I can't do this. Hope someone can hep with this. THanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---