MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: How to keep order of values inside IN() operator
Posted by: Peter Brawley
Date: March 26, 2011 07:04PM

See FIELD() in the manual ...

SELECT *
FROM t
WHERE id IN(7,4,9,5,1)
ORDER BY FIELD(id,7,4,9,5,1));

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to keep order of values inside IN() operator
Lukas Pilny
March 25, 2011 08:53PM
Re: How to keep order of values inside IN() operator
Peter Brawley
March 26, 2011 07:04PM
Re: How to keep order of values inside IN() operator
Lukas Pilny
March 29, 2011 01:06PM


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.