On 5/30/08, Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx> wrote: > > > 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); > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Ron, You can't create a multi-col full text index. You should only create it on the long text field -- Bastien Cat, the other other white meat
