Re: returning results in the order they were selected

on 4/28/05 1:41 AM, Johan Höök at [EMAIL PROTECTED] wrote: > Hi Scott, > you can do: > SELECT a, b, c, from table where zip IN (94949, 94945, 94947) > ORDER BY FIELD(zip,94949, 94945, 94947) That is too handy, thanks for the tip. -- - S

Re: returning results in the order they were selected

Hi Scott, you can do: SELECT a, b, c, from table where zip IN (94949, 94945, 94947) ORDER BY FIELD(zip,94949, 94945, 94947) /Johan Scott Haneda wrote: mysql 4.0.18-standard I am running this select: SELECT a, b, c, from table where zip IN (94949, 94945, 94947) How can I get back a result set in the