I am trying to do a fulltext search with a multi-field index using MySQL 4.1.15.

When I create a full text index of my Comments field which is of type TEXT. I can do a fulltext search fine.

But when I add another field (like a varchar or even Text) to that index or change the name of the index I get and error like:

SELECT * FROM properties WHERE MATCH (CommentsIDX) AGAINST ( "item1 OR item2 AND (item3 AND item4 NOT (item5 OR item6))" WITH QUERY EXPANSION )

MySQL said: Documentation #1054 - Unknown column 'CommentsIDX' in 'where clause'

My table structure contains: FULLTEXT KEY `CommentsIDX` (`Comments`)

Any ideas?

Thanks