Re: Searching shopping cart
| From: | Ron Piggott | Date: | Sat, 31 May 2008 00:37:13 +0000 |
| Subject: | Re: Searching shopping cart | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45017@lists.php.net to get a copy of this message | ||
I don't understand what is going wrong:
CREATE FULLTEXT INDEX
ON shopping_cart_product(product_name, product_description)
gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ON shopping_cart_product(product_name,
product_description)' at line 1
My table is named: shopping_cart_product
I have columns:
product_name varchar(50)
product_description longtext
Ron
On Thu, 2008-05-29 at 12:48 +1000, Chris wrote:
> Ron Piggott wrote:
> > I am getting the following error when running the query through php my
> > admin:
> >
> > MySQL said: Documentation
> >
> > #1191 - Can't find FULLTEXT index matching the column list
>
> Grr - stupid manual didn't have a link on how to create the index.
>
> http://dev.mysql.com/doc/refman/5.0/en/create-index.html
>
> create fulltext index on table(field1, field2);