FULLTEXT Indexes
Learn FULLTEXT Indexes (Full-Text Search, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A FULLTEXT index is an inverted index: it splits text into words (tokens), and for each word stores the list of rows that contain it. It makes word search fast, where LIKE '%word%' would read every row. InnoDB (and MyISAM) support it on CHAR, VARCHAR and TEXT columns.