Stack Exchange
Sum Match Against Relevance not working
I am using Symfony2.7 with Doctrine. My query is working without doing the sum of the relevance in the ORDER BY section. 
What is wrong? Is Doctrine not supporting a sum?
SELECT s.shopArticleId as article_id, 
   MATCH (s.soundex, s.categorySoundex) AGAINST ('T200') AS relevance1,
   MATCH (s.soundex, s.categorySoundex) AGAINST ('A530') AS relevance2

FROM FrontendMainBundle:Search s 

WHERE MATCH (s.soundex, s.categorySoundex) AGAINST ('T200') > 0 
AND MATCH (s.soundex, s.categorySoundex) AGAINST ('A530') > 0 

ORDER BY (relevance1 + relevance2) DESC; 


Yes, Doctrine allows SimpleArithmeticExpression in ORDER BY clausule.

Possible duplicate of MySQL match() against() - order by relevance and column?
