How come a query won’t work when using multiple MATCH AGAINST statements in the where clause?
WHERE
u.sendMatches = ‘Yes’
and MATCH (keyword) AGAINST (‘positiveKeyword*’ in boolean mode)
and MATCH (keyword) AGAINST (‘-negativeKeyword’ in boolean mode)
I realize I can add the positive and negative keywords in one. However, I am trying to keep them separate for code elsewhere on my page. For example, the first MATCH AGAINST would use a positive keyword like ‘head*’, while the second one would use something like ‘-black’. Therefore the results would return searches like headaches but exclude searches like ‘black head’.
Thank you!