Results 1 to 6 of 6
September 17th, 2005, 08:27 PM #1
Question on Match Function of MySql
- Join Date
- June 8th, 2005
I have been using the Match function of MySql for my search. I read somewhere that the Match function will disregard words that are too short and words that appear too many times.
My question is how to overide this feature of Match(). I need to show search terms even if they appear a lot of times in the database.
September 17th, 2005, 09:16 PM #2
I don't know the answer but here is an important part in the mysql documentation that you should read I think. I hope it'll help you.
Any word that is too short is ignored. The default minimum length of words that are found by full-text searches is four characters.
Words in the stopword list are ignored. A stopword is a word such as “the” or “some” that is so common that it is considered to have zero semantic value. There is a built-in stopword list, but it can be overwritten by a user-defined list. See Section 12.7.4, “Fine-Tuning MySQL Full-Text Search ”.
The default minimum word length and stopword list can be changed as described in Section 12.7.4, “Fine-Tuning MySQL Full-Text Search ”.
Every correct word in the collection and in the query is weighted according to its significance in the collection or query. This way, a word that is present in many documents has a lower weight (and may even have a zero weight), because it has lower semantic value in this particular collection. Conversely, if the word is rare, it receives a higher weight. The weights of the words are then combined to compute the relevance of the row."Effective people are not problem-minded; they're opportunity minded. They feed opportunities and starve problems."
September 17th, 2005, 09:25 PM #3
You have to change some parameters and restart the MySQL server.
September 17th, 2005, 11:05 PM #4
- Join Date
- January 18th, 2005
Another good thing to do, because MySQL will not do this for you - check for smaller word sizes in the user input and disregard them. Giving the user feedback on this is always good (and something I keep meaning to do but must admit haven't always).
September 17th, 2005, 11:11 PM #5
I ended up lowering my minimum word size down to 1 letter because I have some 1 letter products (like "W Magazine"). I haven't noticed any downside to doing that. It might make the index a little bigger, but disk space is cheap.
September 18th, 2005, 12:28 AM #6
If you use a boolean fulltext search, you can get around the problem of ignored words due to repetition. So if a word appears more than 50% of the time, it'll still have some weight in the search query.
- ScottHatred stirs up strife, But love covers all transgressions.
By teezone in forum Programming / Datafeeds / ToolsReplies: 5Last Post: June 15th, 2013, 01:12 PM
By AffiliatePhil in forum Credit Card processing and other paymentsReplies: 1Last Post: February 2nd, 2012, 12:09 PM
By Trust in forum eBay Partner NetworkReplies: 3Last Post: July 7th, 2008, 11:03 PM
By Lectrickitty in forum Programming / Datafeeds / ToolsReplies: 11Last Post: March 13th, 2006, 10:37 AM
By zimmy in forum Programming / Datafeeds / ToolsReplies: 3Last Post: April 4th, 2005, 12:14 PM