Is "9640" a word by itself? A full-text search wouldn't find "abc9640", you'd need to use LIKE for that.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Don O'Neil [mailto:[EMAIL PROTECTED] > Sent: Friday, October 20, 2006 2:44 AM > To: mysql@lists.mysql.com > Subject: Problem with query on 5.11 > > Why does this query return no results: > > SELECT * FROM FileList WHERE MATCH Filename AGAINST ("9640") > > When there are entries in the Filename list that have 9640 in them? > > I'm using MySQL 5.1.11. > > Thanks! > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
