MySQL Forums
Forum List  »  Full-Text Search

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How configure Mysql Full Text Search to match formatted numbers like 10.415?
3789
Rogerio Brito
January 14, 2015 03:56PM
Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
2070
Rick James
January 16, 2015 02:42PM
Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
1718
Rogerio Brito
January 17, 2015 11:02AM
Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
2075
Rick James
January 18, 2015 11:29AM


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.