* m n > I have the following table with just one record! And when I do a select > statement, mysql returns no hits!!! > > Would you explain to me what is wrong??
You have only one row. <URL: http://www.mysql.com/doc/en/Fulltext_Search.html > "For very small tables, word distribution does not reflect adequately their semantic value, and this model may sometimes produce bizarre results." More specifically, any word found in more than 50% of the rows are considered as a 'stopword', i.e. it does not give a hit. All you words are in 100% of your rows... ;) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]