Re: Re: Search function query

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 <ron.piggott@actsministries.org> wrote:

I have found the concept I am looking for on the mySQL web site: SELECT MATCH('Content') AGAINST ('keyword1 keyword2') as Relevance FROM table WHERE MATCH ('Content') AGAINST('+keyword1 +keyword2' IN BOOLEAN MODE) HAVING Relevance > 0.2 ORDER BY Relevance DESC I don't know how to apply this to the 3 fields in the data I want to search with the users search string ( product_name , product_description , keywords ) The search string in the form is "search_string" Could someone show me how to make this work with what I have described please? Ron -----Original Message----- From: Ron Piggott <ron.php@actsministries.org> Reply-to: ron.php@actsministries.org To: PHP DB <php-db@lists.php.net> Subject: Search function query Date: Sun, 01 Nov 2009 08:38:13 -0500 I am writing a search function. Is there a way to enhance this query so it will display the best matches first down to the least matches? As well I don't know how to handle if the user types in more than 1 word to search. SELECT * FROM store_product_profile WHERE product_name LIKE '% $search_string%' AND product_description LIKE '%$search_string%' AND keywords LIKE '%$search_string%' Ron