Here's a recipe: create table foo (foo text, bar text);
create fulltext index foo on foo (foo, bar); mysql> show index from foo; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | foo | 1 | foo | 1 | foo | A | NULL | 1 | NULL | YES | FULLTEXT | | | foo | 1 | foo | 2 | bar | A | NULL | 1 | NULL | YES | FULLTEXT | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ Sub_part should be NULL for both of these columns. The same thing happens for a single column fulltext index. -dave /*======================= House Absolute Consulting www.houseabsolute.com =======================*/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]