CakePHP with Sphinx: Searching from multiple indexes

Submitted by Derick Ng on 2 April 2009 - 1:36pm

I was using SphinxBehavior and I ran into a situation where i need to search from a specific index only. My sphinx installation currently has 3 indexes — clients, loans, and companies. By default, the SphinxBehavior searches across these 3. In order to search from 1 index only, you need to do this:

$sphinx = array('index'=>array('clients'),'matchMode' => 'SPH_MATCH_ANY', 'sortMode' => array('SPH_SORT_EXTENDED' => '@weight DESC, @id DESC'));
This makes the bahavior search for the record inside the index clients’ only.
Hope this is helpful.