Sjef Janssen <[EMAIL PROTECTED]> wrote: > 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)?
How many rows in the table? how many rows contain the search word? > >> >> > 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. > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
