Monday, 26 August 2013

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

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

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?

No comments:

Post a Comment