RE: Fulltext behavior in 3.23.58

2005-09-22 Thread Andy Eastham
nitzan shaked [mailto:[EMAIL PROTECTED] > Sent: 22 September 2005 14:57 > To: mysql@lists.mysql.com > Subject: Fulltext behavior in 3.23.58 > > ... this one is peculiar, and I *do* hope there's a workaround: > > Using MySQL 3.23.58 and cannot upgrade. When running "

Fulltext behavior in 3.23.58

2005-09-22 Thread nitzan shaked
... this one is peculiar, and I *do* hope there's a workaround: Using MySQL 3.23.58 and cannot upgrade. When running "SELECT * FROM tblname WHERE match(a) against('very_common_word') LIMIT 1" the whole table is scanned just to give me no results at all. The very common word *does* appear, and a