http://www.mysql.com/doc/F/u/Fulltext_Search.html
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
treated as a stopword (that is, with semantical value zero). It is, really,
the desired behavior - a natural language query should not return every
second row in 1GB table.
Is asp in more than half of the rows of your table?
> Hello,
>
> I have just downloaded version 4 of mySQL. Compiled it with
> ft_min_word_len
> = 0.
> However, my a query like select * from table_name where match(col)
> against('asp')
> returns nothing, when a similar like query returns several rows of data.
> Also a
> query like select * from table_name where match(col)
> against('pl/sql') also
> returns
> nothing.
>
> Is this a bug or am I doing something wrong?
---------------------------------------------------------------------
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
