Owl\Repositories\Eloquent\TagFtsRepository::match PHP Метод

match() публичный Метод

get tags data by string for FullTextSearch.
public match ( $str, integer $limit = 10, integer $offset ) : array
$limit integer
$offset integer
Результат array
    public function match($str, $limit = 10, $offset = 0)
    {
        $query = <<<__SQL__
            SELECT
              ta.name
            FROM
              tags_fts fts 
            INNER JOIN
              tags ta ON ta.id = fts.tag_id
            WHERE
              fts.words MATCH :match
            ORDER BY
              ta.updated_at DESC
            LIMIT 
              {$limit} 
            OFFSET
              {$offset} 
__SQL__;
        return \DB::select(\DB::raw($query), array('match' => FtsUtils::createMatchWord($str)));
    }