Hi,
> Or maybe there are too many. It appears that any word that appears
> in more than half the rows is treated as a stop word:
>
> http://www.mysql.com/doc/F/u/Fulltext_Search.html
>
I read this page but this condition doesnt hurt my mind.
I don t know what happen I modify fait to fiato I regenerate the index.
And find rows with fiat word, the row I find has only word, you devine :
fiat.
My query :
SELECT * FROM T_Stories WHERE match (Heading) against ('+fiat -bagnole' IN
BOOLEAN MODE)
Tell me If I doesn t understand the way mysql treat fulltext in boolean mode
:
so MySQL search rows that has heading wich was ok with +fiat -bagnole
constraint, he has rows, in this rows
if for example : fiat that I want to select is present much more than half
of the data selected in a row, this row is rejected ?
By data selected in a row, here in my sample is * -> the appearance for fiat
in the row is calculated with all the columns ?
Thanks.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
