Ok. I have the index created. ALTER TABLE `shopping_cart_product` ADD FULLTEXT ( `product_description`,`product_name` ) is what worked --- I think the web site http://dev.mysql.com/doc/refman/5.0/en/create-index.html was assuming the creation of a new table. I am able to have both columns in the index. My index is named product_description_search 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') FROM shopping_cart_product Thanks, Ron On Fri, 2008-05-30 at 21:58 -0400, Bastien Koert wrote: > > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
