3 ms·
"Again, depending on the choice of the database-engine, MySQL can lack certain features, such as the full-text search." Both of the two biggest engines (MyISAM
by dkoch 13y ago
"Again, depending on the choice of the database-engine, MySQL can lack certain features, such as the full-text search."
Both of the two biggest engines (MyISAM, InnoDB) support full-text search. It was added to InnoDB in MySQL 5.6/Maria 10.
- McGlockenshire 13y agoGiven all of the odd default behavior and caveats in InnoDB FTS[1], I'd sooner just continue to use an external search solution, like ElasticSearch. 1: http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-text-search-in-mysql-5-6-part-2-the-queries/ http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-t...
- copergi 13y agoInnodb doesn't have fulltext search, it has "fulltext search*". Big difference.