Hi,

I am trying to search by database. The user types in a name and I need to search by database for that name and return with that name and the data associated with it. I have used the below statement to do that but could not get it to work.

public Cursor fetchByName(String RName) throws SQLException
{

String[] COLUMNS = new String[]{KEY_ROWID,
KEY_NAME,
KEY_Description,
KEY_Note};

Cursor mCursor = db.query(DATABASE_TABLE,COLUMNS,KEY_NAME + " MATCH ?", new String[] { RName }, null, null, null);
return mCursor;

}

Prerna