我想在我的eshop中显示相关产品的列表。
问题是,有时比赛太激烈了,有没有办法找到一个有等级的柱子来知道这一排有多匹配?
SELECT * FROM `Items` WHERE MATCH(`Title`,`Text`) AGAINST ('$allText')
我认为这应该能在中工作
SELECT *, MATCH(`Title`,`Text`) AGAINST ('$allText') as grade
FROM `Items` WHERE MATCH(`Title`,`Text`) AGAINST ('$allText')
ORDER BY grade DESC
SELECT *, MATCH(`Title`,`Text`) AGAINST ('$allText') as score
FROM `Items` WHERE MATCH(`Title`,`Text`) AGAINST ('$allText') HAVING score>0.2
这样你就可以限制最好的结果。