Using values from an ArrayList in a where clause without loads of queries?

Question

I'm trying to accomplish basically this:

Select * FROM x WHERE id != for(int i : arraylist)

So basically I have an arraylist with say 10 ids, I want the sql not to return any of the rows that have an ID the same as in my arraylist, and I'd rather not do it with like 10 queries. Is there any way to do this?

Anders R. Bystrup · Accepted Answer · 2014-02-11 00:48:03Z

3

You're looking for the SQL IN keyword:

SELECT * FROM x WHERE id NOT IN ( 1, 2, 3, etc. )

edited Feb 11, 2014 at 0:48

user142162

answered Aug 26, 2013 at 12:48

Anders R. Bystrup

16.1k11 gold badges65 silver badges59 bronze badges

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

Comments

Joe Taras · Accepted Answer · 2013-08-26 13:22:24Z

1

in this way:

SELECT * FROM x WHERE id not in ( list of value ) // i.e. 'A', 'B', ...

Pay attention: You can execute this statement only if yuo array has been filled.

If you have an array with no items NOT IN can cause problems.

So, you must check your condition before put NOT IN clause.

answered Aug 26, 2013 at 13:22

Joe Taras

15.4k7 gold badges45 silver badges59 bronze badges

Collectives™ on Stack Overflow

Using values from an ArrayList in a where clause without loads of queries?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related