Add multiple ColumnCondition to one field

Yii 1.1 General Discussion
1

How to add multiple condition to one field?

I use this, but the latest value use the criteria.


if($value == 1 && !empty($value)) {

$value = 'one'; $value2 = 'two';

$this->_hirdetesExtraCriteria->addColumnCondition(array(

'hirdetesextra.'.$hirdetesextra => $value, 'hirdetesextra.'.$hirdetesextra=>$value2));

}

I would like to this:


column = one or column = two
2

try:

$criteria->addCondition( ‘column = :val1 or column = :val2’ );

$criteria->params[’:val1’] = ‘one’;

$criteria->params[’:val2’] = ‘two’;

3

Thx it works. :)

4

Im trying to do something similar in a named scope but I can’t seem to figure out the syntax:




$rel = relation1;

$this->getDbCriteria()->mergeWith(array(

	'with' => $rel,

	'condition'=>'relation1.column_id=:column_id AND relation1.relation2.column2_id=:column2_id',

	'params'=>array(':column_id'=>$column_id, ':column2_id'=>$column2_id),

));

Can someone please tell me what I am doing wrong?