MySQL Forums
Forum List  »  Full-Text Search

No results when searching for numbers with decimal
Posted by: Jeremy Martin
Date: September 13, 2005 12:30PM


I have recently just about finished some 100% custom forums for several user groups I own ( I set up a binary full text search, to search our existing 250,000 messages (imported into my new forums from our YahooGroups archives).

I have set ft_min_word_len = 3 in my my.cnf and rebuild the indexes. I can search for 3 letter words like "abc" just fine but if I search for a 3 letter version number such as "7.1" I get zero results. I have tried searching for 7.1, "7.1" or '7.1' and even 7\.1 but there are never any results. I have not defined a custom stopword file but I'm wondering if "." is in the default stopwords maybe? It's not a binary operator but I can't figure out why my searches for 7.1 are not giving any results. That number is definitely not found in above 50% of the messages.

Example query searching for just 7.1 in any post since 1999:

SELECT forum_msg_id,match(message,subject) against ('7.1' in boolean mode) as score FROM messages WHERE forum_id = 1 AND match(message,subject) against ('7.1' in boolean mode) AND DATE(posted) >= DATE(FROM_UNIXTIME(937198800)) AND DATE(posted) <= DATE(FROM_UNIXTIME(1126587600)) ORDER BY score DESC, posted DESC LIMIT 25

The software these forums are for often uses 3 digit version numbers like 7.0, 7.1, etc and I'm sure we'll get a lot of searches including those version numbers so I'd like to get this working if possible.

Many thanks!

Options: ReplyQuote

Written By
No results when searching for numbers with decimal
September 13, 2005 12:30PM

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.