Re: Re: Search function query
| From: | Kesavan Rengarajan | Date: | Sun, 01 Nov 2009 18:30:41 +0000 |
| Subject: | Re: Re: Search function query | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46612@lists.php.net to get a copy of this message | ||
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@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 <k7@trk7.com> To: ron.piggott@actsministries.org <ron.piggott@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 +1100SELECT 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 )