problem wuth LIKE in Criteria

Yii 1.1 General Discussion
1

it’s return nuthing




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

  'condition'=>"title LIKE '%:title%'",

  'params'=>array(':title'=>$title),

));

but put a string like ‘i’, it’s return ok




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

  'condition'=>"title LIKE '%i%'",

  'params'=>array(':title'=>$title),

));

did i make mistake?

2

Try like this -

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

‘condition’=>“title LIKE :title”,

‘params’=>array(’:title’=>"%$title%"),

));

3

Thanks!