Friday, February 6, 2015

How to show records in same order where IDs are put into the IN() clause?

 
 
How to show records in same order where IDs are put into the IN() clause? 
 
 
1) SELECT id FROM table1 WHERE ... ORDER BY display_order, name

2) SELECT name, description, ... WHERE id IN ([id's from first])
 
The issue is that the second query does not return the results in the same order 
that the IDs are put into the IN() clause. 
 
Solution :- 

SELECT name, description, ...
FROM ...
WHERE id IN([ids, any order])
ORDER BY FIELD(id, [ids in order])

No comments:

Post a Comment

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...