At 1:00 +0200 4/8/06, Johan Höök wrote:
what you can do is: SELECT [fields] FROM [table] WHERE id IN (id1,id2,id3...) ORDER BY FIELD([field],value1,value2,value3,...)
Ooh - so I can. I didn't know that wrinkle for order by - though I did wonder if something like that should be possible.
Thanks very much! Problem solved. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Consider for a moment any beauty in the name Ralph. -- Frank Zappa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]