创建表

 create table text(
    -> id int not null auto_increment,
    -> texts text null,
    -> primary key(id),
    -> fulltext(texts))engine=myisam;

跟新原有的数据

update text set texts='happer new year!';

查看表中的数据

select * from text;
+----+------------------+
| id | texts            |
+----+------------------+
|  1 | happer new year! |
|  2 | happer new year! |
|  3 | happer new year! |
+----+------------------+

j进行全文本搜索

select texts from text where match(texts) against('new');
Empty set (0.00 sec)

因为默认的最小分词长度是4，new长度只有3，所以被忽略

 show variables like '%ft%';

可以看到ft_min_word_len=4
可先停止MySQL,在my.ini配置文件中增加或修改 ft_min_word_len = 3,再重启MySQL

好的，谢谢