sql 全文检索功能

WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST ('mysql doesnt support fulltext indexes error solving') AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST ('mysql doesnt support fulltext indexes error solving') AND post_date <= '2007-11-17 06:41:45' AND (post_status IN ( 'publish', 'static' )) AND post_password = '' ORDER BY score DESC LIMIT 5

大意就是不支持全文索引，解决方案也挺简单的，打开my.ini
搜索

default-storage-engine=

你搜索到的应该是

default-storage-engine=INNODB

把INNODB改成MyISAM重新启动Mysql吧，Done