> You can't create a multi-col full text index. You should only create it > on the long text field
'Course you can. mysql> create table a(a int, b varchar(50), c text); Query OK, 0 rows affected (0.01 sec) mysql> create fulltext index fulltext_bc on a(b,c); Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 Just the syntax of the create index statement wasn't right. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
