FullText Search

[xbl1]

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

[aspnetguy]

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.

[xbl1]

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);

[aspnetguy]

is this MySql or Oracle? Your positive that those words exist in Topic and Des?

[jesh]

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

[justsomeguy]

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.

[xbl1]

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.