[prev in list] [next in list] [prev in thread] [next in thread]
List: php-db
Subject: Re: [PHP-DB] Searching shopping cart
From: Ron Piggott <ron.php () actsministries ! org>
Date: 2008-05-31 3:31:08
Message-ID: 1212204668.3089.3.camel () localhost ! localdomain
[Download RAW message or body]
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@actsministries.org> 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic