Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?

[Rick James]

Consider the following issues in your test case:
* If more than half the rows contain a particular word ("Service"), that word is not considered (at least in MyISAM). (The "50% rule".)
* The default setting for MyISAM is ft_max_word_len = 4; did you decrease that? If not, then A&O is ignored in MyISAM. Sorry, I should have observed that 'New' is 3 characters. Note that innodb_ft_min_token_size defaults to 3.

Perhaps you would like to modify the test case in the bug report before they jump on you for those issues.

There are differences between the two implementations of FULLTEXT.
See this for the settings you are using:
SHOW VARIABLES LIKE '%ft%';
If you change any settings, you will need to rebuild the FT index(es).