FullText Search

[xbl12]

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

 

[TonyGroves]

Some of those words are probably too common. It won't return results for certain words like "the". That list of words is built-in to the system and as far as I know can't be changed.

 

[towerbase]

xbl12, I suggest you read the documentation on the

http://www.mysql.com

site.

Here is an extract from

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Some words are ignored in full-text searches:

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.

Andrew
Hampshire, UK

 

[xbl12]

Thanks a lot, i understand it now.