Order by umm OR?

[Yoed]

Hi,

Lets say I have a query similar to:

SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ;

I want to be able to get the results to come out ordered by the order
the ids were searched (the sequence in the WHERE OR; 3 first then 1,
then 7...), so the results would be like:

Row | id | name
-------------------
0 | 3 | Joe's Co
1 | 1 | Buymart
2 | 7 | The big evil

As it is the results returns it like id 1, then 3, and 7.

Thanks for your help guys,
Best,
Yoed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw