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 order of the `IN` part of the statement?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
