Filter CMS page collection by title or content

Question

I'm working on a module to make certain CMS pages searchable on the front end. Right now I'm having a little trouble filtering the pages. I get the collection, filter it by an "is_searchable" field that I've added, which is working fine. When I try to filter it by title or content using a like statement, it either returns no results, or every result, regardless of if that matches the title/content at all or not. Here's what I'm using so far:

$results = Mage::getModel('cms/page')->getCollection()
               ->addFieldToFilter('title', array('like'=> '%' . $search . '%'))
               ->addFieldToFilter('content', array('like'=>'%' . $search . '%'))
               ->addFieldToFilter('is_searchable', 1);

I also tried using addAttributeToFilter() but get an error that that function doesn't exist in that model. Not sure what I'm doing wrong here, but any help or direction would be appreciated. Thanks!

Answer 1

The answer by @MauroNigrele comes close, but the actual syntax to combine several conditions for different fields with OR is different.

The following should work:

$results = Mage::getModel('cms/page')->getCollection()
    ->addFieldToFilter(
        ['title', 'content'],
        [['like' => "%{$search}%"], ['like' => "%{$search}%"]]
     )
     ->addFieldToFilter('is_searchable', 1);

You can find a more detailed documentation of addFieldToFilter() in this answer: addFilter vs addFieldToFilter

Answer 2

In this query you are looking for pages with both title and content like $search i mean AND not OR.

If you need to build an OR statement the right syntax is:

$results = Mage::getModel('cms/page')->getCollection()
     ->addFieldToFilter(array(
        array('field'=> 'title','like' => "%{$search}%"),
        array('field'=> 'content','like' => "%{$search}%"),
     ))
     ->addFieldToFilter('is_searchable', 1);

You can always view your query logging the select:

Mage::log($results->getSelectSql(true),7,'my-sql.log');

Remember that addAttributeToFilter() method is only available for EAV entities and these are: catalog_product, catalog_category ,customer_customer and customer_address