Searching shopping cart
| From: | Ron Piggott | Date: | Thu, 29 May 2008 02:01:01 +0000 |
| Subject: | Searching shopping cart | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45011@lists.php.net to get a copy of this message | ||
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