Hi,
I have a query like this:
select id, title from product where id in (1,3,5,8,10)
What I want it to do is return the rows in the order specified in the
"in" clause, so that this:
select * from product where id in (10,3,8,5,1)
will give me results in this order:
+------+---------+
| id | title |
+------+---------+
| 10 | foo |
+------+---------+
| 3 | baz |
+------+---------+
| 8 | bar |
+------+---------+
| 5 | wibble |
+------+---------+
| 1 | flirble |
+------+---------+
Is this possible? If so, how?
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
