MySQL Forums :: Newbie :: showing records in order given by in clause


Advanced Search

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.

Options: ReplyQuote


Subject Written By Posted
showing records in order given by in clause John Phan 05/06/2011 09:44PM
Re: showing records in order given by in clause Guelphdad Lake 05/06/2011 09:59PM


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.