The '0' relevance is probably because 'postcard' is present in a lot of rows . Try adding more rows with different content and also try searching for different products. Your query looks fine to me.
Sent from my iPhone

On 02/11/2009, at 4:53 AM, Ministry Office <off...@actsministries.org> wrote:


Yes.  All the search results have a '0' relevance result.

When I created the FULLTEXT index I made all three fields one index with the keyname "customer_search" --- is my query wrong, should I be using 'customer_search'?

Ron

-----Original Message-----
From: Kesavan Rengarajan <k...@trk7.com>
To: ron.pigg...@actsministries.org <ron.pigg...@actsministries.org>
Cc: PHP DB <php-db@lists.php.net>
Subject: Re: [PHP-DB] Re: Search function query
Date: Mon, 2 Nov 2009 04:11:45 +1100

SELECT MATCH ( `product_name` , `product_description` , `keywords` )
AGAINST ( 'postcard' ) AS Relevance
FROM store_product_profile
WHERE MATCH ( `product_name` , `product_description` , `keywords` )
AGAINST ( 'postcard'
IN BOOLEAN
MODE )

Reply via email to