How to construct sql query for mutiple where values

Question

I need to build a query.

Below is the table of my DB:

ID          Name
20          ABC1
30          ABC2
40          ABC3
60          ABC4
70          ABC5
80          ABC6

I need to get the records for the ID's 30 , 40 , 70.

I have written a query as below , but its giving me error.

String query =  "SELECT * FROM tableName WHERE ID = '30','40','70' "

The above query I am passing to below method:

db.rawQuery(query ,null);

but its throwing below error:

I/SqliteDatabaseCpp(19091): sqlite returned: error code = 1, msg = near ",": syntax error, db=xxx

Please let me know what can be do to resolve the issue.

String query = "SELECT * FROM tableName WHERE ID IN ('30','40','70') " — Suvitruf - Andrei Apanasik
– Suvitruf - Andrei Apanasik, Commented Mar 25, 2014 at 10:17

alandarev · Accepted Answer · 2014-03-25 10:17:42Z

2

You need to write instead WHERE ID IN ('30', '40', '70')

Also I strongly suggest you using db.query instead of db.rawQuery to avoid the possible sql injection attack or general string escaping mistakes.

answered Mar 25, 2014 at 10:17

alandarev

8,6452 gold badges37 silver badges43 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:11:11Z

2

You can use regular SQL syntax for that:

String query =  "SELECT * FROM tableName WHERE ID = '30' OR ID = '40' OR ID = '70' "

By the way, you can use in convenient android way:

Exapmle

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Mar 25, 2014 at 10:17

sygi

4,6872 gold badges38 silver badges57 bronze badges

Comments

hooknc · Accepted Answer · 2019-05-30 19:31:32Z

0

String query = "SELECT * FROM tableName WHERE ID in ('30','40','70')"

edited May 30, 2019 at 19:31

hooknc

5,0055 gold badges37 silver badges65 bronze badges

answered Mar 25, 2014 at 10:21

Gurudev S Kallahally

94 bronze badges

Collectives™ on Stack Overflow

How to construct sql query for mutiple where values

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related