How to create a criteria condition for a multiple value text search i.e a "LIKE IN"

How-tos

search, like, in, cdbcriteria

For a scenario where only the name field above is the only condition a single CDbCriteria instance will do i.e


```php
$c1= = new CDbCriteria; foreach ($search_values as $txt) { $c1->compare('name', $txt, true, 'OR');
}
``````php
$c1= = new CDbCriteria; // original criteria $c2= = new CDbCriteria; // criteria for handling our search values foreach ($search_values as $txt) { $c2->compare('name', $txt, true, 'OR');
}```php
$c1= = new CDbCriteria; // original criteria $c2= = new CDbCriteria; // criteria for handling our search values foreach ($search_values as $txt) { $c2->compare('name', $txt, true, 'OR'); } $c1->addCondition($c2->condition); $c1->params += $c2->params; // Add the params for $c2 into $c1 ```