全文索引fulltext

-- 创建索引
alter table add index `full_text_idx` on tablename (`column_name`);

-- 类似like的查询
select * from course_comment where MATCH(content) AGAINST ('太棒了' IN NATURAL LANGUAGE MODE);

-- 包含County或Down的查询
MATCH(name) AGAINST('+County +Down' IN BOOLEAN MODE)