MySQL Forums
Forum List  »  Newbie

Order by my order. How to ?
Posted by: bennie blanco
Date: November 08, 2010 04:49AM

Hello , I am trying to sort the order of the result by my order

example
SELECT *
FROM mytable
WHERE id
IN ( 85, 75, 52, 51 )
LIMIT 0 , 30

is there wnay way to sort this result like this 85, 75, 52, 51 instead rand , odering , id , id asc , id desc and so on ?

Options: ReplyQuote


Subject
Written By
Posted
Order by my order. How to ?
November 08, 2010 04:49AM
November 08, 2010 04:55AM
November 08, 2010 05:34AM
November 08, 2010 05:33AM


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.