全文索引

ALTER TABLE mall_shop_template ADD FULLTEXT INDEX page_name (`page_name`) WITH PARSER ngram    创建全文索引

$where = "MATCH(page_name) AGAINST ('".$page_name."')";   全文索引查询方法

posted @ 2018-12-11 09:40  冷空气的清晰  阅读(76)  评论(0编辑  收藏  举报