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. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
