using "in" in query

[steven290]

when i run this query

select * from table where id in (5,4,3,2,5)

it only returns 4 rows instead of 5

I'm assuming that its combining the duplicate ids (5)

Does any one know how to avoid this?

 

[swampBoogie]

select t.* 
from t
inner join 
  (select 5 id union all 
   select 4 union all 
   select 3 union all 
   select 2 union all
   select 5) dt
on t.id = dt.id

 

[TonyGroves]

Or simply:
[tt]
SELECT * FROM table WHERE id=5
UNION ALL
SELECT * FROM table WHERE id=4
UNION ALL
SELECT * FROM table WHERE id=3
UNION ALL
SELECT * FROM table WHERE id=2
UNION ALL
SELECT * FROM table WHERE id=5