, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
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 F
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
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:[EM
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
