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:
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
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
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.
Regards,
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.
Regards,
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:
Why does
, 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 Filename list that have 9640 in them?
How