fulltext query

[WayneK]

Greetings,

I am turning to the fine FutureQuest community for assistance.

I have created a table with a FULLTEXT (Title,Author,Description) index

However my queries fail with this error message

AAAAAack! the durn query failed:
errorno=1191
error=Can't find FULLTEXT index matching the column list
query=SELECT * FROM Maps WHERE MATCH (Title,Author,Description) AGAINST ('beers')

Any ideas where I should look? The Mysql manual has not given me any joy.

tia
[This message has been edited by WayneK (edited 06-06-01@11:32 pm)]

[WayneK]

Got it

Had to do with my index name....I think