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

[Rick James]

I would have two columns
* One with the text to display
* One with text for FULLTEXT searching

The ft column would have various things cleaned up/removed:
* remove thousands separators
* remove html tags
* change decimal points to "_" or something that ft will match.
* whatever else FULLTEXT might stumble over.

I question whether matching on numeric values is wise. In some cases, you might want to match "approximately". This is really tricky, and probably should not involve FULLTEXT.

Perhaps changing
ft_boolean_syntax = "+ -><()~*:""&|"
to "+ -><()~*:""&|.," and rebuilding the index would work; I don't know. However, it would probably mess with periods and commas in sentences. So, not a good idea.