I am having unexpected behaviour with this query:
SELECT cvid,WEIGHT() as weight FROM index WHERE MATCH(’“pr manager”’) ORDER BY weight DESC LIMIT 0,50 OPTION max_matches=50, ranker=expr(‘sum((4lcs+2(min_hit_pos==1)+exact_hit)*user_weight)1000+bm25-7diffindays’), field_weights = (title=5,summary=3)
my results include the following:
- Project Manager, Technical Engineer
- Junior Product Marketing Manager, Advanced use of Microsoft Office, portfolio management skills.
So I am searching for “pr manager” and the results include “Project Manager” and “Product manager”.
I would expect that using double quotes would only include only the exact phrase.
Any ideas? thx!