mysql用于检索的关键字_Mysql全文搜索match...against的用法
??????????????MyISAM?????????????MyISAM????? ??????????????CHAR?VARCHAR?TEXT?????????
发布日期:2025-04-18 04:42:45
浏览次数:15
分类:精选文章
本文共 1602 字,大约阅读时间需要 5 分钟。
MySQL?????Full-Text Search?FTS??????MyISAM????????????????????????????MySQL??????????
?????????
??????FULLTEXT????????????????????????????????????????????MyISAM???????CHAR?VARCHAR?TEXT????????????????????????????????????????????????
?????????
?????????
?????????????MySQL???????????????????MySQL????????????????????????????????
??my.cnf???
??MySQL??????????
/etc/my.cnf??
[mysqld]?????????ft_min_word_len = 2ft_wordlist_charset = gbkft_wordlist_file = /home/soft/mysql/share/mysql/wordlist-gbk.txtft_stopword_file = /home/soft/mysql/share/mysql/stopwords-gbk.txt
???
ft_min_word_len = 2?????????????????4???2????????ft_wordlist_charset???????????????UTF-8?GBK?GB2312?BIG5?ft_wordlist_file????????????GBK????????ft_stopword_file?????????????????????
????MySQL???
- ?????????????MySQL???????????
???????
???????????
- ??
CREATE TABLE???????????FULLTEXT?????CREATE INDEX?????????
CREATE TABLE articles ( id INT PRIMARY KEY, title VARCHAR(255), content TEXT, tags FULLTEXT) ENGINE=MyISAM;
??????????
- ????????????
ALTER TABLE?????????
ALTER TABLE articles ADD FULLTEXT INDEX index_tags ON articles(tags);
???????
???????
- ?
SELECT?????MATCH???AGAINST???
SELECT * FROM articles WHERE MATCH(tags) AGAINST('??' IN BOOLEAN MODE);???????
IN BOOLEAN MODE??????????????AGAINST????????????????MATCH????????????
??????
???????
- ?????????????????????????????????????????????????
???????
- ??
OPTIMIZE INDEX???????????????
??
MySQL???????????????????????????????????????????????????????????????????????????????????????????????
发表评论
最新留言
很好
[***.229.124.182]2026年06月05日 07时47分39秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!