MySQL中的全文搜索不返回任何行-FULLTEXTsearchinMySQLdoesnotreturnanyrows

I am a bit lost, this looks like some silly mistake - but I have no clue what that can be. Here is the test session:

我有点迷路了，这看起来像是一个愚蠢的错误——但是我不知道那会是什么。以下是测试环节:

mysql> drop table articles;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE articles (body TEXT, title VARCHAR(250), id INT NOT NULL auto_increment, PRIMARY KEY(id)) ENGINE = MYISAM;
Query OK, 0 rows affected (0.02 sec)

mysql> ALTER TABLE articles ADD FULLTEXT(body, title);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> insert into articles(body) values ('Maya');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM articles  WHERE MATCH(title, body) AGAINST('Maya');
Empty set (0.00 sec)

mysql> select * from articles
    -> ;
+------+-------+----+
| body | title | id |
+------+-------+----+
| Maya | NULL  |  1 |
+------+-------+----+
1 row in set (0.00 sec)

This is on "mysqld Ver 5.1.37-1ubuntu5 for debian-linux-gnu on i486 ((Ubuntu))".

这是在“mysqld Ver 5.1.37-1ubuntu5上的debian-linux-gnu在i486 (Ubuntu)上”。

Here is the script for simple cut and paste (please try it and verify if it works on your system):

这里是简单剪切粘贴的脚本(请尝试并验证它是否在您的系统上工作):

CREATE TABLE articles (body TEXT, title VARCHAR(250), id INT NOT NULL auto_increment, PRIMARY KEY(id)) ENGINE = MYISAM;
ALTER TABLE articles ADD FULLTEXT(body, title);
insert into articles(body) values ('Maya');
SELECT * FROM articles  WHERE MATCH(title, body) AGAINST('Maya');     

2 个解决方案

INSERT INTO articles(body) VALUES ('Some text'), ('Another text');

SELECT * FROM articles  WHERE MATCH(title, body) AGAINST('Maya' IN BOOLEAN MODE);