Custom orderBy with FIELD - doctrine-user

Message from discussion Custom orderBy with FIELD

J.Philip

More options 9 July, 01:53

From: "J.Philip" <jphi...@noatak.com>

Date: Wed, 8 Jul 2009 16:53:15 -0800

Local: Thurs 9 July 2009 01:53

Subject: RE: [doctrine-user] Custom orderBy with FIELD

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

You can do this in Doctrine with a RawSql query.

-----Original Message-----
From: doctrine-user@googlegroups.com [mailto:doctrine-user@googlegroups.com]

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

Reply to author Forward