SQlite Query in android using cursor

Question

My Query is SELECT DefaultId FROM tblsample where ('567' = DefaultId) || ('567' = Name)

In the above query

table name = tblsample 
Column Names = DefaultId , Name
Input Value  = 567

Now i want to check this value is available in which column from the table and return its DefaultId. I am able to achieve this in Sqlite, want to know is there still better way to optimize the query and In android using

database.query(boolean distinct, String table, String[] columns,String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)

which query i must use in android.

JulianHarty · Accepted Answer · 2017-02-16 22:51:10Z

5

Use this snippet:

String table = "tblsample";
String selection = "DefaultId =? OR Name=?";
String[] selectionArgs = new String[]{"567"};
String[] projection = new String[]{"DefaultId","Name"}; // if you want to fetch only these two columns

Before your database.query:

database.query(true, table, projection, selection, selectionArgs, null, null, null, null);

Change the values for distinct, limit, orderBy, having and groupBy if you need them.

edited Feb 16, 2017 at 22:51

JulianHarty

3,3365 gold badges36 silver badges48 bronze badges

answered Mar 10, 2015 at 7:04

YFeizi

1,5283 gold badges29 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Munchoo Over a year ago

i accept your answer but why i must give my selectionArgs an Array instad its a single value

YFeizi Over a year ago

Usually its an array of values then use it as an array , i dont test it with one value and a single String variable.

YFeizi Over a year ago

whats wrong with my answer @Munchoo ? i cant understand why you didnt accept my answer :/

Munchoo Over a year ago

i tried accepting both answers but i do not know that we can accept only one. sorry changed nw

YFeizi · Accepted Answer · 2015-03-10 07:20:45Z

1

You can use SQLiteDatabase documentation to guide you.

Table

table = "tblsample";

Columns

columns = new String[]{"DefaultId"};

Where

selection = "DefaultId =? OR Name=?";
selectionArgs = new String{"567"};

edited Mar 10, 2015 at 7:20

YFeizi

1,5283 gold badges29 silver badges52 bronze badges

answered Mar 10, 2015 at 7:09

Omer Sonmez

1,1682 gold badges20 silver badges31 bronze badges

Comments

Vignesh Bala · Accepted Answer · 2015-03-10 07:34:42Z

1

String sql = "SELECT DefaultId FROM tblsample where (DefaultId = 567) OR (Name = 567)";
Cursor cursor=database.rawQuery(sql,null);
if(cursor != null && cursor.getCount()>0){
    //value available
} else{
    //not avail
}

edited Mar 10, 2015 at 7:34

answered Mar 10, 2015 at 7:18

Vignesh Bala

6642 gold badges12 silver badges24 bronze badges

1 Comment

YFeizi Over a year ago

Is it possible to use || in SQLite ?

Collectives™ on Stack Overflow

SQlite Query in android using cursor

3 Answers 3

4 Comments

Table

Columns

Where

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Table

Columns

Where

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related