title: How to concatenate fields in select statements using Doctrine
body: <p>I'm wondering how to concatenate two fields in DQL select statement with some literal between.</p>
  
  <p>I have this for now but no luck...</p>
  
  <pre><code>$qb
              -&gt;select('season.id, concat(competition.name, '-',season.name) AS specs')
              -&gt;leftJoin('season.competition', 'competition')
              -&gt;where('season.name LIKE :q')
              -&gt;setParameter('q', '%'.$q.'%')
              -&gt;setMaxResults($p)
          ;
  </code></pre>