How To Include Both Columns In Where Clause For Searching

I want to search my data from either of two table columns but the following code is not working what can I do ??? Cursor c = queryBuilder.query(ourHelper.getReadableDatabase()

Solution 1:

Bro, it is easy .... I hope it will work for your where clause

String where = KEY_ADDRESS  + "=" + variable + " and " + KEY_ROWID  + "='" + var_id + "'";
Cursor c = mDb.query(true, TABLE_MENUS, new String[] { your column name}, where, null, null, null, null, null);