essage-
From: Kesavan Rengarajan
To: ron.pigg...@actsministries.org
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
an Rengarajan
To: ron.pigg...@actsministries.org
Cc: PHP DB
Subject: Re: [PHP-DB] Re: Search function query
Date: Mon, 2 Nov 2009 03:21:56 +1100
Please have a look at this page: http://imysql.cn/docs/MySQL_51_en/ch12s07.html
.
Hope that is helpful.
Sent from my iPhone
On 02/11/2009, at 1:45
ame` , `product_description` , `keywords`
)
AGAINST (
'postcard'
IN BOOLEAN
MODE
)
HAVING Relevance > 0.2
ORDER BY Relevance DESC
-Original Message-
From: Kesavan Rengarajan
To: ron.pigg...@actsministries.org
Cc: PHP DB
Subject: Re: [PHP-DB] Re: Search function query
Date: Mon, 2
Please have a look at this page: http://imysql.cn/docs/MySQL_51_en/ch12s07.html
.
Hope that is helpful.
Sent from my iPhone
On 02/11/2009, at 1:45 AM, Ron Piggott
wrote:
I have found the concept I am looking for on the mySQL web site:
SELECT MATCH('Content') AGAINST ('keyword1 keyword2'