mysql order by issue

w4rezarena.com

New Member
if i have a query like :\[code\]SELECT * FROM table WHERE id IN (3,6,1,8,9);\[/code\]this array of the ids is build in php dynamically ,and the order is important to me.\[code\]$my_array = array (3,6,1,8,9) ;\[/code\]how can i sort the results by the order by which the elements appear in my array ?its possible to do it in MYSQL query,or i must to order it after via php ?
 
Back
Top