, 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
e-
> 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&
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
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
