Hello.
> #1054 - Unknown column 'CommentsIDX' in 'where clause' > My table structure contains: FULLTEXT KEY `CommentsIDX` >(`Comments`) You should use column names not index names in your queries. Please, provide CREATE statement for your tables and problematic queries. With this information it'll be easier to help you. Michael Stearne wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]