MySQL 加入和匹配/针对搜索失败

发布于 2024-11-06 08:57:46 字数 490 浏览 3 评论 0 原文

我基本上是想创建一个搜索来查找文章（或作者的文章）。我最终得到了这个查询：

   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`

我已确保所有四个匹配的字段都是全文索引。搜索会匹配并找到由名字为“Kevin”的用户发表的所有文章，但如果我搜索名为“Test”（存在）的文章，则不会匹配。

原文

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).

分享到QQ

分享到微博