showing records in order given by in clause
Posted by:
John Phan
Date: May 06, 2011 09:44PM
mysql automatically orders the query I give by the ID. Was wondering if it was possible to show the records in the same order I gave in the IN clause.
select * from table where ID in (10,6,4,3,7,8,19,1,2)
will just give me back each record starting from the lowest ID. What can I do? Thanks.
Subject
Written By
Posted
showing records in order given by in clause
May 06, 2011 09:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.