Fulltext Search with InnoDB

by

Along with the general phasing out of MyISAM, InnoDB full-text search (FTS) is finally available in MySQL 5.6.4 release.

Lots of juicy details at https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html.

While other engines have lots of different features, this one is InnoDB, so it’s native (which means there’s an upgrade path), and that makes it a worthwhile option.

More Related Contents:

  1. How to search multiple columns in MySQL?
  2. Which SQL query is better, MATCH AGAINST or LIKE?
  3. MySQL full text search for words with three or less letters
  4. Any way to achieve fulltext-like search on InnoDB
  5. VARCHAR as foreign key/primary key in database good or bad?
  6. How to implement a Keyword Search in MySQL?
  7. Join vs. sub-query
  8. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  9. Natural Sort in MySQL
  10. MySQL get row position in ORDER BY
  11. Subqueries vs joins
  12. MySQL Results as comma separated list
  13. MySQL unknown column in ON clause
  14. Maintaining order in MySQL “IN” query
  15. MySQL: What is a reverse version of LIKE?
  16. Select TOP X (or bottom) percent for numeric values in MySQL
  17. MySQL select where column is not empty
  18. Hamming distance on binary strings in SQL
  19. Is it possible to have a default parameter for a mysql stored procedure?
  20. Renaming foreign-key columns in MySQL
  21. How to convert from varbinary to char/varchar in mysql
  22. MySQL GROUP BY behavior
  23. How to regex in a MySQL query
  24. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  25. Update multiple rows with one query?
  26. How do I list all the columns in a table?
  27. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  28. MySql bulk load command line tool
  29. ALTER TABLE without locking the table?
  30. MySQL: Typecasting NULL to 0

Leave a Comment