MySQL5.7から実装されるInnoDBの全文検索 in
CJKモードの挙動について。
Natural Language Full-Text Searchsについて。
12.9.1 Natural Language Full-Text Searches
http://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier,
the MATCH() function performs a natural language search for a
string against
a text collection. A collection is a set of one or more columns
included in a FULLTEXT index.
The search string is given as the argument to AGAINST().
検証用DB、テーブル、データの作成。
…