首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >利用人工智能(如谷歌)搜索MySQL的最佳方法

问利用人工智能(如谷歌)搜索MySQL的最佳方法
EN

Stack Overflow用户
提问于 2014-04-12 14:52:50
回答 2查看 1.7K关注 0票数 0

我正在构建一个网络爬虫,它收集爬行结果到MySQL表中。

有五个主要列:URL, TITLE, DESCRIPTION, KEYWORDS, BODY。

目前,我正在使用FULLTEXT的MySQL搜索功能,如下所示:

代码语言:javascript
复制
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。

有什么建议吗?

EN

回答 2

Stack Overflow用户

发布于 2015-12-10 09:08:11

代码语言:javascript
复制
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匹配。见上面的代码。谢谢你!

票数 0
EN

Stack Overflow用户

发布于 2014-04-12 14:54:10

看看像SoundEx这样的东西:

请参阅:http://www.madirish.net/?article=85

另外,你能不能不考虑自己做加权:(我没有MySQL本地的,很抱歉半伪码)

代码语言:javascript
复制
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;";
票数 -1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/23031931

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档