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

User · Answer

Try this  this works for my code name is a String   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

User · Answer

I came here for a reminder of how to set up the query but the existing examples were hard to follow  Here is an example with more 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     Parameters   table  the name of the table you want to query columns  the column names that you want returned  Don t return data that you don t need  selection  the row data that you want returned from the columns  This is the WHERE clause   selectionArgs  This is substituted for the   in the selection String above  groupBy and having  This groups duplicate data in a column with data having certain conditions  Any unneeded parameters can be set to null  orderBy  sort the data limit  limit the number of results to return

User · Answer

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       quot TableName quot        new String    quot ColumnName quot          quot ColumnName LIKE   quot        new String    data  quot   quot         null       null       null     while c moveToNext            your calculation goes here

User · Answer

Alternatively  db rawQuery sql  selectionArgs  exists   Cursor c   db rawQuery select  null

User · Answer

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

[android] How to perform an SQLite query within an Android application?

Examples related to android

Examples related to sqlite

Examples related to android-sqlite