> 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')
> 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)