--test表建立text字段的全文索引
CREATE FULLTEXT INDEX fidx_title On test(text) with parser ngram;
--查询语句
SELECT * from test where match(text) against ('你好*' in boolean mode)
--test表建立text字段的全文索引
CREATE FULLTEXT INDEX fidx_title On test(text) with parser ngram;
--查询语句
SELECT * from test where match(text) against ('你好*' in boolean mode)