根据Doctrine 2中的值自定义ORDER BY子句

Question

I am trying to use custom sorting in Doctrine 2 (using MySQL). Code looks somehow like this:

$queryBuilder->orderBy("i.type = 5, i.type = 3, i.type = 7");

The error I get is this one: [Syntax Error] line 0, col 72: Error: Expected end of string, got '='.

I have found out that this is not possible because of compatibility with other database systems. So my questions is: How can do this in other way, directly in the query (if possible)?

Answer 1

Well, at the end, I haven't solution I wanted, but I had to do something else. At the end, the result was the desired one.

I selected the data normally and than by going throught the array and using array sort finished the job.