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 an 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]