Using Multiplication in the DQL Doctrine Order by clasuse

Question

I am using doctrine 2.1 DQL and I want to get table data in this order:

SELECT u FROM User u ORDER BY us * ut 

s and t are the two displayed column fields on the user.

But I get a QueryException.

Can anybody help me?

Answer 1

this should do the trick:

 SELECT u, (us * ut) AS multiplication FROM User u ORDER BY multiplication