No, there are just a few rows in my table, as I am still developing the program. Will it be better when the table is in regular use (and the number of rows will increase)? Sj
> > > 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]