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 <office@xxxxxxxxxxxxxxxxxx>
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 <k7@xxxxxxxx>
To: ron.piggott@xxxxxxxxxxxxxxxxxx <ron.piggott@xxxxxxxxxxxxxxxxxx>
Cc: PHP DB <php-db@xxxxxxxxxxxxx>
Subject: Re: 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 )
