php - MATCH IN BOOLEAN MODE 与现有记录不匹配？

Question

所以我得到了这个看似简单的查询:

SELECT i.*, 
    g.title AS groupname, 
    c.name AS category, 
    v.name AS author, 
    w.name as moderator, 
    u.name AS editor 
FROM `jos_k2_items` as i 
    LEFT JOIN `jos_k2_categories` AS c ON c.id = i.catid 
    LEFT JOIN `jos_viewlevels` AS g ON g.id = i.access 
    LEFT JOIN `jos_users` AS u ON u.id = i.checked_out 
    LEFT JOIN `jos_users` AS v ON v.id = i.created_by 
    LEFT JOIN `jos_users` AS w ON w.id = i.modified_by 
WHERE i.trash=0 
    AND MATCH( i.title ) AGAINST ('+red* +2*' IN BOOLEAN MODE)
ORDER BY i.id DESC

由管理员界面中的 Joomla 搜索构建。我正在尝试查找名为 RED 2 的文章，但没有返回任何结果。下面是该行的一个片段:

id  title   alias   catid   published ... trash
===============================================
800 RED 2   red-2   5       1             0

表上有两个全文索引。第一个在 title 列上，第二个在 title, introtext, fulltext, extra_fields_search, image_caption, image_credits, video_caption, video_credits, metadesc, metakey 上。

我尝试的其中一件事是重建索引，我使用了以下命令:

REPAIR TABLE `jos_k2_items` QUICK;

Answer 1

您尝试匹配短于默认最小全文索引长度 3 的单词

首先改变那个限制

ft_min_word_len = 3

到 2 或 1。

然后重启mysql，重建表上的索引:

你可以这样做:

REPAIR TABLE my_table QUICK;