RE: Fulltext and 2 to 3 character words...

2001-05-19 Thread Chris Bolt
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 n

Fulltext and 2 to 3 character words...

2001-05-19 Thread technical Support
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