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>
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'?
From: Kesavan Rengarajan <k...@trk7.com>
To: ron.pigg...@actsministries.org <ron.pigg...@actsministries.org>
Cc: PHP DB <firstname.lastname@example.org>
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
WHERE MATCH ( `product_name` , `product_description` , `keywords` )
AGAINST ( 'postcard'