Re: [PHP-DB] Searching shopping cart

> 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/