Weighted, Paginated MySQL Search Query for CakePHP
CakePHP formatted, weighted MySQL query
$this->paginate = array( 'fields' => "*, (MATCH (title) AGAINST ('$q' IN BOOLEAN MODE)*100) + (MATCH (body) AGAINST ('$q' IN BOOLEAN MODE)*10) + MATCH (clients) AGAINST ('$q' IN BOOLEAN MODE) AS rating", 'conditions' => "MATCH (title,body,clients) AGAINST ('$q' IN BOOLEAN MODE)", 'order' => 'rating DESC', 'limit' => 10 ); $results = $this->paginate('Article');