Don O'Neil wrote:
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?
How many rows are in the table? Full text won't work with only a couple of rows.
And you do have a full text index on the filename field right? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]