主页 / dba / 问题 / 76653
Accepted
Jakub Turcovsky
Asked: 2014-09-16 23:21:54 +0800 CST

MATCH AGAINST 一个字符的单词返回 ft_min_word_len = 1 的空行

  • 772

我已经设置ft_min_word_len = 1为my.cnf文件，也SHOW VARIABLES LIKE 'ft_min_word%'显示ft_min_word_len as 1. 然后我重新加载了所有数据库表，它仍然没有搜索一个字符的单词。

我的桌子：

CREATE TABLE IF NOT EXISTS event (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(80) NOT NULL,
description TEXT,
time TIMESTAMP DEFAULT 0,
FULLTEXT(name)
);

我的查询：

SELECT event.id AS eid,
    event.name AS ename
FROM event
WHERE MATCH(event.name) AGAINST('+W*' IN BOOLEAN MODE)

我正在搜索的事件名称是W.W.W. + Pavel Fajt + Vladimir 518 @ Sono

请问还有什么可能导致问题？

编辑：我正在使用 InnoDB，抱歉我之前没有提到它。

mysql my.cnf

1 个回答

  1. Best Answer
    mysql> SHOW GLOBAL VARIABLES like 'ft_min_word_len';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| ft_min_word_len | 1     |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SELECT event.id AS eid,     
              event.name AS ename 
       FROM event 
       WHERE MATCH(event.name) AGAINST('+W*' IN BOOLEAN MODE);
+-----+--------+
| eid | ename  |
+-----+--------+
|   1 | W.W.W. |
|   7 | W      |
|  12 | Wa     |
|  11 | Wat    |
|  10 | Wats   |
|   9 | Watso  |
|   8 | Watson |
+-----+--------+
7 rows in set (0.01 sec)

    也许你正在使用 InnoDB：

    mysql> ALTER TABLE event ENGINE=InnoDB;
Query OK, 12 rows affected (0.51 sec)
Records: 12  Duplicates: 0  Warnings: 0

mysql> SELECT event.id AS eid,
       event.name AS ename 
       FROM event 
       WHERE MATCH(event.name) AGAINST('+W*' IN BOOLEAN MODE);
+-----+--------+
| eid | ename  |
+-----+--------+
|   8 | Watson |
|   9 | Watso  |
|  10 | Wats   |
|  11 | Wat    |
+-----+--------+
4 rows in set (0.00 sec)

    更改选项的位置是innodb_ft_min_token_size（ft_min_word_len仅适用于 MyISAM）。

    • 7

相关问题