Excellent. Worked like a dream. Thanks. Andrew
-----Original Message----- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs Sent: 23 September 2004 15:14 To: [EMAIL PROTECTED] Subject: Re: Sorting by a comma list I think SELECT id, title, description FROM table1 WHERE id IN (4,1,3,6,8,2) ORDER BY field(id,4,1,3,6,8,2) should work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
