1.fecify 如果进行中文搜索,需要安装mysql5.7
2.更改索引
ALTER TABLE fecpx_addons_language_product DROP INDEX ft_index_title_and_body_html;
CREATE FULLTEXT INDEX ft_index_title_and_body_html ON fecpx_addons_language_product (`title`,`body_html`) WITH PARSER ngram
ALTER TABLE fecpx_shop_product DROP INDEX ft_index_title_and_body_html;
CREATE FULLTEXT INDEX ft_index_title_and_body_html ON fecpx_shop_product (`title`,`body_html`) WITH PARSER ngram