Searching shopping cart

[email protected] (Ron Piggott)
Newsgroups php.db
Organization Acts Ministries Christian Evangelism
Message-ID <[email protected]>
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 Relevance
FROM ( shopping_cart_category INNER JOIN shopping_cart_product ON
shopping_cart_category.reference =
shopping_cart_product.category_reference ) INNER JOIN
shopping_cart_product_image ON
shopping_cart_product_image.product_reference =
shopping_cart_product.reference INNER JOIN shopping_cart_inventory ON
shopping_cart_inventory.product_reference =
shopping_cart_product.reference WHERE MATCH
(shopping_cart_product.product_description,
shopping_cart_product.product_name) AGAINST('$keyword' IN BOOLEAN MODE)
HAVING Relevance > 0.2 ORDER
BY Relevance DESC
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.