MySQL Forums :: Newbie :: Order by my order. How to ?


Advanced Search

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 ? bennie blanco 11/08/2010 04:49AM
Re: Order by my order. How to ? Large Arnaud 11/08/2010 04:55AM
Re: Order by my order. How to ? laptop alias 11/08/2010 05:34AM
Re: Order by my order. How to ? bennie blanco 11/08/2010 05:36AM
Re: Order by my order. How to ? bennie blanco 11/08/2010 04:58AM
Re: Order by my order. How to ? bennie blanco 11/08/2010 05:00AM
Re: Order by my order. How to ? Large Arnaud 11/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.