title: DQL and multiple WHERE statements
body: <p>I want to write query with multiple <code>WHERE</code> statements.</p>
  
  <pre><code>$query = $this-&gt;createQueryBuilder('s');
  
      $query-&gt;select('s.id,s.internalId as internal_id,s.firstName as first_name,s.lastName as last_name,st.name as store_name,sts.name as status_name')
          -&gt;leftJoin('s.store', 'st')
         -&gt;leftJoin('s.studentStatus', 'sts')
          -&gt;where($query-&gt;expr()-&gt;orx(
              //$query-&gt;expr()-&gt;eq('s.store_id', ':location'),
              $query-&gt;expr()-&gt;like('s.internalId', ':internalId'),
              $query-&gt;expr()-&gt;like($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.firstName)'), ':name'),
              $query-&gt;expr()-&gt;like($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.lastName)'), ':name'),
              $query-&gt;expr()-&gt;like($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.firstName)'), $query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.lastName)')), ':name'),
              $query-&gt;expr()-&gt;like($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.lastName)'), $query-&gt;expr()-&gt;concat($query-&gt;expr()-&gt;literal(' '), 'lower(s.firstName)')), ':name')
          ))
          -&gt;setParameter('name', "%{$term}%")
          -&gt;setParameter('internalId', "%{$internalId}")
          //-&gt;setParameter('location', "{$location}")
          -&gt;orderBy('s.lastName', 'ASC')
          -&gt;setMaxResults((int) $limit);
  </code></pre>
  
  <p>Commented line in the above query is not working.</p>