On Tue, Nov 9, 2010 at 10:09 AM, Mark Goodge <m...@good-stuff.co.uk> wrote: > 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? >
select * from product where id in (10,3,8,5,1) order by field(id,10,3,8,5,1) should do the trick... Regards, Joeri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
