Why is the request not working?

Question

Sphinx

I can not understand why the request does not work and how to fix it.

$query   = $pdo->prepare("
                   SELECT *, WEIGHT() AS weight
                   FROM {$index} WHERE MATCH (:search)
                   OPTION ranker=proximity_bm25, max_query_time=3, max_matches=300
                ");
                $query->bindValue(':search', $q, \PDO::PARAM_STR);
                $query->execute();
                     
                $rows = $query->fetchAll(\PDO::FETCH_ASSOC);

Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''(Company | *Company*)') OPTION ranker=prox' at line 2

What the final query looks like:
SELECT *, WEIGHT() AS weight FROM companyIndex WHERE MATCH (Company | *Company*) OPTION ranker=proximity_bm25, max_query_time=3, max_matches=300

Answer 1

SELECT *, WEIGHT() AS weight FROM companyIndex WHERE MATCH (Company | *Company*) OPTION ranker=proximity_bm25, max_query_time=3, max_matches=300

Missing single quotes aroundКомпания | *Компания*

Answer 2

https://dev.mysql.com/doc/refman/8.0/en/fulltext-s...

MATCH (col1,col2,...) AGAINST (expr [search_modifier])

There are no OPTIONs in MySQL.

Answer 3

So you send a request to the sphinx or a muscle?