Hi, > I am trying to understand the logic of full text search in mysql. I'm not > using mysql 4. The search work OK, be it thast I get hits on certain > words, whilst other words are discarded for some reason or other. Why is > that. An example: I search in a text field for the word organisation. I > get hits. When I search for the word scenario nothing is found. But I can > see the word in the paragraphs by myself? > Is there an explanation for this?
AIUI, if a word occurs too many times (in more than x% of rows, I can't remember the logic used) then it's treated as a "stop" word. This means that words that appear in almost every row (like "the", "you" etc) which would have no value to a search are ignored. I believe this is what's causing your problem. Do you have many records in the table you're doing a fulltext search on? IME it tends to work better with plenty of rows to work with. HTH! David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]