> 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)
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 i
On 5/30/08, Ron Piggott <[EMAIL PROTECTED]> 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
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 ï»
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.
Ron Piggott wrote:
> Someone referred me to:
>
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
>
> Does this look like I am on the right track?
>
> Ron
>
> SELECT MATCH(shopping_cart_product.product_description,
> shopping_cart_product.product_name) AGAINST ('$keyword') as Releva
