让MYSQL支持全文索引
1.修改/etc/mysql/my.cnf[client]
default-character-set = gbk
[mysqld]
default-character-set = gbk
ft_stopword_file = /usr/share/mysql/stopwords-gbk.txt
ft_min_word_len = 2
2.上传/usr/share/mysql/stopwords-gbk.txt文件stopwords-gbk.txt
3.重起MYSQL
4.repair table tablename;