Android - sqlite in clause using values from array which contains same values multiple times

Question

I want to execute a sqlite query:

select * from table_name where id in (23,33,33,55,43,23);

if any value is appearing in the array twice, cursor should contain the corresponding row twice.

I am getting each row only one time. The array contains same id twice. So i want that row shown in the cursor two times. — Jossy Paul
– Jossy Paul, Commented Jun 12, 2014 at 5:21
It will only check the row's someID against the values of the IN(). It doesn't matter how your IN() looks like, it will not return more results than there are rows that matches that value — Giru Bhai
– Giru Bhai, Commented Jun 12, 2014 at 5:53

Community · Accepted Answer · 2017-05-23 12:27:25Z

1

Yes run a for loop or use a join:

SELECT T.*
FROM (
  SELECT 23 AS id
  UNION SELECT 33
  ...
  UNION SELECT 23) AS list
LEFT JOIN table_name T ON list.id = T.id

CommunityBot

11 silver badge

answered Jun 12, 2014 at 5:24

weston

55k23 gold badges151 silver badges209 bronze badges

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

1 Answer 1