有没有办法确保IN
子句中的所有值都匹配?
例子:
我可以用as:IN (5,6,7,8)
.
我需要它在多行中像AND
一样工作.
UPDATE:
public function actionFilters($list)
{
$companies = new CActiveDataProvider('Company', array(
'criteria' => array(
'condition'=> 'type=0',
'together' => true,
'order'=> 'rating DESC',
'with'=>array(
'taxonomy'=>array(
'condition'=>'term_id IN ('.$list.')',
)
),
),
));
$this->render('index', array(
'companies'=>$companies,
));
}