我正在构建一个网络爬虫,它收集爬行结果到MySQL表中。
有五个主要列:URL, TITLE, DESCRIPTION, KEYWORDS, BODY。
目前,我正在使用FULLTEXT的MySQL搜索功能,如下所示:
SELECT URL,title, description, MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode)
AS score FROM record
WHERE MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode) order by score desc;";但这并没有给我带来好的结果。请考虑下面的图像。

在这里,facebook在搜索"Facebook".(?)上排名第23位
我可以根据颜色名称来确定搜索的优先级吗?例如,我希望查询将最大优先级赋予URL,然后是description,然后是title,keywords。最后是body。
有什么建议吗?
发布于 2015-12-10 09:08:11
SELECT URL,title, description, MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode) AS score FROM record WHERE URL LIKE '%$keyword%' OR MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode) order by score desc;";只需使用LIKE操作符进行URL匹配。见上面的代码。谢谢你!
发布于 2014-04-12 14:54:10
看看像SoundEx这样的东西:
请参阅:http://www.madirish.net/?article=85
另外,你能不能不考虑自己做加权:(我没有MySQL本地的,很抱歉半伪码)
SELECT
URL
,title
, description
, MATCH (URL) AGAINST ('$keyword' in boolean mode) AS urlscore
, MATCH (description) AGAINST ('$keyword' in boolean mode) AS descscore
, MATCH (title) AGAINST ('$keyword' in boolean mode) AS titlescore
, MATCH (body) AGAINST ('$keyword' in boolean mode) AS bodyscore
,((MATCH (URL) AGAINST ('$keyword' in boolean mode))*4)
+ ((MATCH (description) AGAINST ('$keyword' in boolean mode))*3)
+ ((MATCH (title) AGAINST ('$keyword' in boolean mode))*2)
+ ((MATCH (body) AGAINST ('$keyword' in boolean mode))*1) as weightedscore
FROM
record
WHERE
MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode)
order by
((MATCH (URL) AGAINST ('$keyword' in boolean mode))*4)
+ ((MATCH (description) AGAINST ('$keyword' in boolean mode))*3)
+ ((MATCH (title) AGAINST ('$keyword' in boolean mode))*2)
+ ((MATCH (body) AGAINST ('$keyword' in boolean mode))*1) desc;";https://stackoverflow.com/questions/23031931
复制相似问题