How to perform an SQLite query within an Android application?

Question

I am trying to use this query upon my Android database, but it does not return any data. Am I missing something?

SQLiteDatabase db = mDbHelper.getReadableDatabase();     String select = "Select _id, title, title_raw from search Where(title_raw like " + "'%Smith%'" +     ")";             Cursor cursor = db.query(TABLE_NAME, FROM,              select, null, null, null, null);     startManagingCursor(cursor);     return cursor; 

Answer 1

This will return you the required cursor

Cursor cursor = db.query(TABLE_NAME, new String[] {"_id", "title", "title_raw"},                  "title_raw like " + "'%Smith%'", null, null, null, null);