MySQL Forums
Forum List  »  Full-Text Search

Fulltext anomaly
Posted by: Martin O'Shea
Date: June 14, 2008 10:37AM


I have just sttarted using natural language fulltext searching in MySQL. I have a table made up of fields:

Name VARCHAR(50)
Description VARCHAR(255)

And I have a fulltext index as (Description) which works but what I don't understand is this:

I have data:

ID | Name | Description
1 | Water | London tapwater WC1

And if I run a query like:

SELECT Name, Description
FROM MyTable
WHERE MATCH(Description) AGAINST('London')

I get the row above returned. But when the same query is changed to:

SELECT Name, Description
FROM MyTable

Nothing is returned.

Yet I can't understand why this is the case; to me, both queries should return the same data.

Any advice would be welcome.

Martin O'Shea.

Edited 1 time(s). Last edit at 06/14/2008 10:43AM by Martin O'Shea.

Options: ReplyQuote

Written By
Fulltext anomaly
June 14, 2008 10:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.