我有一个mysql全文搜索,我为按相关性排序结果设置了一个分数值,我的问题是我想给与关键字100%匹配的记录一个更好的分数SELECT Title, MATCHthe da vinci code") the vinci code' IN BOOLEAN MODE) HAVING Score>=2 ORDER BY Score DESC;
问题是,如果我有名为“达芬奇密码,终极指南”或“达芬奇密码图解指南”的书,它们会得到与我最相关的书相同的分数,丹·布朗的“达芬
我有一个这种格式的数据集:
The Da Vinci Code book is just awesome.1 this was the first clive cussler i've ever read, but even books like Relic, and Da Vinci code were more plausible than this.1 i liked the Da Vinci Code a lot.1 da vinci code was an awesome movie...1 the last stand and Miss