How to execute a SQLite query in an Android application?

Question

I am trying to use this query in an Android database, but it does not return any data. Did I miss 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 the cursor you need.

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

Answer 2

Alternatively there is db.rawQuery (sql, selectionArgs).

 Cursor c = db.rawQuery(select, null); 

Answer 3

This will also work if the pattern you want to match is a variable.

 dbh = new DbHelper(this); SQLiteDatabase db = dbh.getWritableDatabase(); Cursor c = db.query("TableName", new String[]{"ColumnName"} , "ColumnName LIKE ?" ,new String[]{_data+"%"}, null, null, null); while(c.moveToNext()) { // your calculation goes here } 

Answer 4

I came here to remind you how to configure the request, but the existing examples were not easy. Here is an example with a lot of explanation.

 SQLiteDatabase db = helper.getReadableDatabase(); String table = "table2"; String[] columns = {"column1", "column3"}; String selection = "column3 =?"; String[] selectionArgs = {"apple"}; String groupBy = null; String having = null; String orderBy = "column3 DESC"; String limit = "10"; Cursor cursor = db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy, limit); 

Options

• table : the name of the table you want to query
• columns : the names of the columns you want to return. Do not return data that you do not need.
• selection : the data of the row you want to return from the columns (this is a WHERE clause.)
• selectionArgs : is this being replaced by ? in the selection String above.
• groupBy and having : these groups duplicate data in a column with data that has certain conditions. Any unnecessary parameters can be set to zero.
• orderBy : sort data
• limit : limit the number of returned results

Answer 5

Try this, this works for my code name - line:

 cursor = rdb.query(true, TABLE_PROFILE, new String[] { ID, REMOTEID, FIRSTNAME, LASTNAME, EMAIL, GENDER, AGE, DOB, ROLEID, NATIONALID, URL, IMAGEURL }, LASTNAME + " like ?", new String[]{ name+"%" }, null, null, null, null);