gog
1
What exactly are the rules when the field search operator (Manticore Search Manual: Searching > Full text matching > Operators) is in parentheses? For example
MATCH(' (@title one) two ')
Is this valid altogether? Will “two” be searched for in “title” or everywhere?
Sergey
2
Please use explain query
to understand it, e.g.:
mysql> drop table if exists t; create table t(title text); explain query t ' (@title one) two '\G
--------------
drop table if exists t
--------------
Query OK, 0 rows affected (0.05 sec)
--------------
create table t(title text)
--------------
Query OK, 0 rows affected (0.00 sec)
--------------
explain query t ' (@title one) two '
--------------
*************************** 1. row ***************************
Variable: transformed_tree
Value: AND(
AND(fields=(title), KEYWORD(one, querypos=1)),
AND(KEYWORD(two, querypos=2)))
1 row in set (0.00 sec)