title: Symfony2/Doctrine QueryBuilder using andwhere()
body: <p>I am using following method in a repository class to look for certain tags in my database:</p>
  
  <pre><code>public function getItemsByTag($tag, $limit = null)
  {
      $tag = '%'.$tag.'%';
  
      $qb = $this-&gt;createQueryBuilder('c');
  
      $qb-&gt;select('c')
         -&gt;where($qb-&gt;expr()-&gt;like('c.tags', '?1'))
         -&gt;setParameter(1, $tag)
         -&gt;addOrderBy('c.clicks', 'DESC');
  
      if (false === is_null($limit))
          $qb-&gt;setMaxResults($limit);
  
      return $qb-&gt;getQuery()-&gt;getResult();
  }
  </code></pre>
  
  <p>This works just nice.. But: How can I add 2 additional variables (where: reviewed = 1, enabled = 1)? I tried andwhere() but I couldn't figure it out.</p>
  
  <p>I also found out that something like this:</p>
  
  <pre><code>public function getItems($limit = null)
  {
          $qb = $this-&gt;createQueryBuilder('b')
                 -&gt;select('b')
                 -&gt;add('where', 'b.reviewed = 1')
                 -&gt;add('where', 'b.enabled = 1')
                 -&gt;addOrderBy('b.name', 'ASC');
  
          // ...
  }
  </code></pre>
  
  <p>won't work either...</p>
  
  <p>Any hints?</p>