gistfile1.txt

// FULLTEXT search
if (! empty($filters['q'])) {
    $pattern = 'leastone';
    $term = format_search_string($filters['q'], $pattern);

    $mode = ' IN BOOLEAN MODE';
    $full_text_bool_expr = array(
        "(5*MATCH(`tenders`.`title`) AGAINST ('{$term}'{$mode}))",
        "(3*MATCH(`tenders`.`description`) AGAINST ('{$term}'{$mode}))",
    );

    $bool_relevance = \DB::raw(
        '('.implode(' + ', $full_text_bool_expr).')'
    );

    $mode = '';
    $full_text_natural_expr = array(
        "(5*MATCH(`tenders`.`title`) AGAINST ('{$term}'{$mode}))",
        "(3*MATCH(`tenders`.`description`) AGAINST ('{$term}'{$mode}))",
    );
    $natural_relevance = \DB::raw(
        '('.implode(' + ', $full_text_natural_expr).')'
    );

    $query
        ->addSelect(\DB::raw("{$bool_relevance} as `bool_relevance`"))
        ->addSelect(\DB::raw("{$natural_relevance} as `natural_relevance`"))
        ->whereRaw("MATCH (`tenders`.`searchable`) AGAINST ('{$term}' IN BOOLEAN MODE)")
        ->orderBy('bool_relevance', 'desc')
        ->orderBy('natural_relevance', 'desc');
}