On 10/30/07, Johan Höök <[EMAIL PROTECTED]> wrote: > Hi, > what you probably want is > SELECT id, start_date FROM iddt WHERE id IN > ('109k7','s3x6','sxmns','wt57') > ORDER BY FIELD(id,'109k7','s3x6','sxmns','wt57')
That's exactly it! Thanks a lot :-) Just for the record, here's the FIELD() function description: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field PaPa