On Behalf Of conankun
Sent: Wednesday, July 08, 2009 4:48 PM
To: doctrine-user
Subject: [doctrine-user] Custom orderBy with FIELD

Hi,

I would like to know if it's possible to do a custom orderBy with
Doctrine? In other words, is there any Doctrine equivalent to this
SQL:

SELECT * FROM `table` ORDER BY FIELD(id,2,5,3,6,4,1);

I know I can do a normal Doctrine_Query and traverse the results array
and do manual sorting (which is my current alternative), however it
would be good if I can just grab the custom sorted data straight from
the SQL (since MySQL also supports this).

If it's currently not possible, I hope it will be added in the future,
thx.

PS: Let me know if this suppose to be a support ticket or something.

Cheers,
HC