mysql 全文索引

新建索引

ALTER TABLE test ADD FULLTEXT INDEX ft_index (name) WITH PARSER ngram;

普通查询

SELECT name from test WHERE MATCH (name) AGAINST("菩萨 波罗蜜多时" IN NATURAL LANGUAGE MODE);

多条件查询

SELECT * from  message_queue_history  where MATCH(message) AGAINST('+10086 +小明' IN BOOLEAN MODE);