MySQL加入和匹配/搜索失败 [英] MySQL Join and Match/Against Search Fail

问题描述

我基本上试图创建搜索来查找文章（或来自作者的文章）。我已经结束了这个查询：

  SELECT`articles`。*，`authors`。* 
 FROM `articles` 
 LEFT JOIN`authors` ON（`authors`.`id` =`articles`.`author_id`）
 WHERE MATCH（`articles`.`title`，`articles`.`描述`）
 AGAINST（test）
或MATCH（`authors`.`first_name`，`authors`.`last_name`）
 AGAINST（test）
 GROUP BY`articles`.`id` 
  

我确定所有四个匹配的字段都是全文索引。搜索匹配并找到用户名为'Kevin'的所有文章，但如果我搜索名为'Test'的文章（它存在），则不匹配。

解决方案

匹配will 不是找到停止单词的分数。 在$ 50％的结果中发生，
或在正式停用词列表™中。

请参阅： http://dev.mysql.com/doc/refman/5.5/en/fulltext- stopwords.html

And： http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

对于微调Match Match，请参阅：< a href =http://dev.mysql.com/doc/refman/5.5/en/fulltext-fine-tuning.html =nofollow> http://dev.mysql.com/doc/refman/ 5.5 / en / fulltext-fine-tuning.html

I'm basically trying to create a search to find articles (or articles from an author). I've ended up with this query:

   SELECT `articles`.*, `authors`.*
     FROM `articles`
LEFT JOIN `authors` ON (`authors`.`id` = `articles`.`author_id`)
    WHERE MATCH (`articles`.`title`, `articles`.`description`)
            AGAINST ("test")
       OR MATCH (`authors`.`first_name`, `authors`.`last_name`)
            AGAINST ("test")
 GROUP BY `articles`.`id`

I have made sure that all four matched fields are FULL TEXT indexes. The search matches against and finds all articles made by a user with first name 'Kevin' but will not match if I search for articles named 'Test' (which exists).

解决方案

Match against will not find a score for "stop" words.

Stop words are words that occur in 50%+ of the results,
or that are in the official stop word list™.

See: http://dev.mysql.com/doc/refman/5.5/en/fulltext-stopwords.html
And: http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

For finetuning Match Against see: http://dev.mysql.com/doc/refman/5.5/en/fulltext-fine-tuning.html

这篇关于MySQL加入和匹配/搜索失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！