How do you keep the order using SELECT WHERE IN()?
Posted
by Pepper
on Stack Overflow
See other posts from Stack Overflow
or by Pepper
Published on 2010-05-11T19:37:48Z
Indexed on
2010/05/11
19:44 UTC
Read the original article
Hit count: 184
Filed under:
mysql
Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query:
SELECT id FROM data_table WHERE id IN(56,55,54,1,7);
The results will come back using the default order by id. 1,7,54,55,56
When I want to keep the order used in the IN: 56,55,54,1,7
Is there a quick way to do this in mySQL or will I be forced to order it after in code.
Thanks :)
© Stack Overflow or respective owner
