Re: [PHP-DB] Searching shopping cart

2008-06-01 Thread Chris
> Would someone show me a sample query from the table? I have tried to > get this to work during the past half hour and I don't understand this > type of query yet. > > Where I am at with my search query that doesn't work is: > > SELECT MATCH ( 'product_description_search') AGAINST ( 'Jesus')

Re: [PHP-DB] Searching shopping cart

2008-06-01 Thread Chris
> 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)