We can use MATCH AGAINST with zend select where clause.
Ex:
$selectQry = $this->db->select()->from(array('D'=>$this->_name))
->joinLeft(array('C'=>TBL_CATEGORIES),
'C.category_id = D.category_id',array('category_id'))
->where('D.is_deleted = ?', 0)
->where('MATCH(C.name) AGAINST (?)', $txt)
->orWhere('MATCH(D.name,D.summary,D.description) AGAINST (?)', $txt)
->group('D.destination_id');
Ex:
$selectQry = $this->db->select()->from(array('D'=>$this->_name))
->joinLeft(array('C'=>TBL_CATEGORIES),
'C.category_id = D.category_id',array('category_id'))
->where('D.is_deleted = ?', 0)
->where('MATCH(C.name) AGAINST (?)', $txt)
->orWhere('MATCH(D.name,D.summary,D.description) AGAINST (?)', $txt)
->group('D.destination_id');