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/[EMAIL PROTECTED]