MySQL Forums
Forum List  »  Newbie

Mysql Fulltext search question
Posted by: dilcher
Date: June 20, 2005 09:36AM

I am doing a "non boolean" normal fulltext search in my database of text articles.

When I do a non boolean search for just:
wanda

I get something like 11 hits.

When I do a non boolean search for:
A fish called wanda

I get something like 1000 hits.

Is this normal? Shouldn't the longer query be more restrictive and give back less results?

Maybe my mistake is thinking everything in my query should be in the returned "hit". When I looked at the results, many of those 1000 hits actually didn't have the word wanda in them.

So, in a non boolean fulltext search, words in the query don't really have to be in the resulting hits?

Confused!

Options: ReplyQuote


Subject
Written By
Posted
Mysql Fulltext search question
June 20, 2005 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.