title: Matching all values in IN clause
body: <p>Is there a way to ensure all values in an <code>IN</code> clause are matched?</p>
  
  <p>Example:</p>
  
  <p>I can use IN as: <code>IN (5,6,7,8)</code>.</p>
  
  <p>I need it to work like an <code>AND</code> across multiple rows.</p>
  
  <p><strong>UPDATE:</strong>
  I need this to list companies from db that fit specified parameters. Companies and taxonomy are MANY TO MANY relation. I'm using Yii framework. And this is the code of my controller:</p>
  
  <pre><code>public function actionFilters($list)
  {
      $companies = new CActiveDataProvider('Company', array(
          'criteria' =&gt; array(
              'condition'=&gt; 'type=0',
              'together' =&gt; true,
              'order'=&gt; 'rating DESC',
              'with'=&gt;array(
              'taxonomy'=&gt;array(
                  'condition'=&gt;'term_id IN ('.$list.')',
                  )
              ),
          ),
      ));
      $this-&gt;render('index', array(
          'companies'=&gt;$companies,
      ));
  }
  </code></pre>