xbl1 Posted December 14, 2006 Share Posted December 14, 2006 Could anyone known why the fulltext search just can find some words but not all of the words, For instance the following words, it could not find;man, job, in for, when etc Link to comment Share on other sites More sharing options...
aspnetguy Posted December 14, 2006 Share Posted December 14, 2006 can you show us your code and describe the situation you are using it in. words like "the, and, a, in, to" are filter out because they are considered irrelavent to search results. Link to comment Share on other sites More sharing options...
xbl1 Posted December 14, 2006 Author Share Posted December 14, 2006 can you show us your code and describe the situation you are using it in. words like "the, and, a, in, to" are filter out because they are considered irrelavent to search results.I run the following sql statement, but it does not return result.SELECT * FROM Customer WHERE MATCH (Topic,Des) AGAINST ('man' IN BOOLEAN MODE);orSELECT * FROM Customer WHERE MATCH (Topic,Des) AGAINST ('job' IN BOOLEAN MODE); Link to comment Share on other sites More sharing options...
aspnetguy Posted December 14, 2006 Share Posted December 14, 2006 is this MySql or Oracle? Your positive that those words exist in Topic and Des? Link to comment Share on other sites More sharing options...
jesh Posted December 14, 2006 Share Posted December 14, 2006 Could anyone known why the fulltext search just can find some words but not all of the words, For instance the following words, it could not find;man, job, in for, when etc MySQL ignores words that are 3 letters or smaller by default. This would explain why "man" and "job" are ignored. It also has a list of stop words - words that appear very often in text so to include them would mean returning lots of meaningless results. This explains why "in", "for", and "when" are ignored.This link talks a little bit about that:http://dev.mysql.com/doc/refman/5.0/en/ful...ine-tuning.html Link to comment Share on other sites More sharing options...
justsomeguy Posted December 14, 2006 Share Posted December 14, 2006 Also, I think that if a word appears in 50% or more of the rows in the table, it ignores that word in normal operation. Link to comment Share on other sites More sharing options...
xbl1 Posted December 15, 2006 Author Share Posted December 15, 2006 Also, I think that if a word appears in 50% or more of the rows in the table, it ignores that word in normal operation.Thanks a lot, i undersstand it now. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now