MySQL ODBC Connector - Problem with FullText Indexes

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem with FullText Indexes

Michael Stearne

2005-12-28, 3:23 am

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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links