Jump to content

FullText Search


xbl1
 Share

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...