From: Martijn Tonies Date: January 28 2005 3:41pm Subject: Re: FULLTEXT index on InnoDB tables List-Archive: http://lists.mysql.com/mysql/179089 Message-Id: <02a001c5054f$e245d5f0$3802a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello, > I would need to index FULLTEXT two columns in a InnoDB table. How do you solve > the problem? As you have noticed - you cannot. So, all you can do is creating a MyISAM table and copying the column contents. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com