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 <> 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'?


-----Original Message-----
From: Kesavan Rengarajan <>
To: <>
Cc: PHP DB <>
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'

Reply via email to