469,111 Members | 1,987 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

order by question

SELECT * FROM kf_gallery WHERE gallery_id IN ( 3, 1, 2 ) ORDER BY ?

What I'm trying to do is get the results in the order specified in the "IN"
clause, i.e. (3, 2, 1). Is this possible? (I'm having trouble searching
the mail archives). Thanks!

-m
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1030

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Neal | last post: by
11 posts views Thread by Bhushit Joshipura | last post: by
9 posts views Thread by Steven T. Hatton | last post: by
8 posts views Thread by der | last post: by
4 posts views Thread by Frank Wallingford | last post: by
16 posts views Thread by mdh | last post: by
15 posts views Thread by Jeroen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.