MySQL order when using IN ()

Question

I am getting some records from sorted table and would like to ask some other table for records with the same ... lets say ... id.

SELECT * FROM duckies WHERE fluffy_id IN (<array_of_fluffy_ids>) ...

Is there any way to order the query result exactly the same way as fluffy_ids in IN() clause?

Alma Do · Accepted Answer · 2013-10-11 09:47:23Z

7

Yes, there is. Use FIELD() function:

SELECT 
  * 
FROM 
  duckies 
WHERE 
  fluffy_id IN (<array_of_fluffy_ids>) 
ORDER BY 
  FIELD(fluffy_id, <array_of_fluffy_ids>)

answered Oct 11, 2013 at 9:47

Alma Do

37.4k10 gold badges81 silver badges106 bronze badges

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

1 Comment

Great, thank you! I will accept the answer in 10 minutes. It does exactly what I wanted.