Hi,
I have these 2 queries:
SELECT id, name, weight() FROM index1 WHERE MATCH (‘carbimazole macleods tablets 20mg’);
±--------±----------------------------------±---------+
| med_id | commercial_name | weight() |
±--------±----------------------------------±---------+
| 4650877 | Carbimazole Macleods Tablets 20mg | 10610 |
±--------±----------------------------------±---------+
1 row in set (0.25 sec)
all well, result is correct, then I do:
SELECT id, name, weight() FROM index1 WHERE MATCH (‘carbimazole macleods 20mg tablets’);
Empty set (0.00 sec)
Is this the correct result ? As I am not using a phrase operator “” but the default AND operator I would expect the different position of the terms to give different weight results but still return a result.
Am I missing something ?
Thanks
Roberto