Fulltext anomaly

[Martin O'Shea]

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.