MySql全文搜索 [英] MySql Full text Search

问题描述

在我的招聘网站上，我需要显示与正在查看的职位类似的职位。我正在尝试以下查询，但它不起作用：

  SELECT *，
 MATCH（title）AGAINSTSales协调员作为相关性
 FROM 
工作
其中
 MATCH（标题）反对销售协调员
 ORDER BY相关性DESC 
限额100 
  

另外，这可以优化吗，以便提供更好的结果，也许更快？

$ b $你真的需要澄清什么是不工作（即没有发现什么）和电流有多快。我假设你在title字段创建了一个全文索引？

你可能正在寻找IN BOOLEAN MODE选项。

  MATCH（title）AGAINST（销售*协调员*在布尔模式中）
  

这会找到像推销员的东西。

In my Job listings site, I need to show jobs which have similar titles to the one which is being viewed. I am trying the following query, but its not working:

SELECT  *, 
MATCH(title) AGAINST "Sales Coordinator" as relevance
FROM
  jobs
WHERE
  MATCH(title) AGAINST "Sales Coordinator"
ORDER BY relevance DESC
LIMIT 100

Also, can this be optimized, so as to give better results and maybe faster too?

解决方案

You really need to clarify what is not working (i.e. what is it not finding) and how fast the current is. I assume you created a full text index on the "title" field?

You might be looking for the "IN BOOLEAN MODE" option.

MATCH(title) AGAINST ("Sales* Coordinator*" IN BOOLEAN MODE)

That would find things like "salesman".

这篇关于MySql全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！