Fulltext anomaly
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.
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.