[RESOLVED] keeping query order

[tito]

I am doing a query in table thread

WHERE t.threadid in (44371,44373,44374,44372,44375)

How can I make the results display in that input order and not by threadid as it seems to automatically order them by?

thanks

[Lars_Berg]

add this at the end of yuor query

order by case threadid 
  when 44371 then 1
  when 44373 then 2
  when 44374 then 3
  when 44372 then 4
  when 44375 then 5 end

[tito]

thanks, but those id are dynamically generated

[Lars_Berg]

So, generate the order by clause dynamically.

[tito]

Cool, thanks.... I got it

[bradgrafelman]

Don't forget to mark this thread resolved.