MySQL Forums
Forum List  »  Newbie

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

Written By
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.