… records with name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning… front of our search term, then that term *must* appear in the search results. But does it? With 5.5: mysql: SELECT id… that actually matches all three search terms, and in this case, both MyISAM and InnoDB FTS performed identically and found it. I…

…-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, … to traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the important…find that kind of behavior unsettling. I don’t like case-sensitivity in my table or column names…