MySQL Forums
Forum List  »  Full-Text Search

Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
Posted by: Rick James
Date: January 16, 2015 02:42PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
1348
January 16, 2015 02:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.