MySQL Forums
Forum List  »  Full-Text Search

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

Hello

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

ID VARCHAR (15)
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
WHERE MATCH(Description) AGAINST('WC1')

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


Subject
Views
Written By
Posted
Fulltext anomaly
4364
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.