This is an old version of this answer!
Return to the current answerYpu could try concatenating all columns you want to look into, and then use LIKE in the criteria. Something like this:
$term = '%test%';
$c = new Criteria();
$c->clearSelectColumns();
$c->addSelectColumn('concat('
. CommentPeer::BODY . ",'|',"
. CommentPeer::TITLE . ",'|'"
. ') as A');
$c->add('A', $term, Criteria::LIKE);
$rs = CommentPeer::doSelectRS($c);
Arturo Linares | 05/06/10 at 11:44am