Search function query
| From: | Ron Piggott | Date: | Sun, 01 Nov 2009 13:38:05 +0000 |
| Subject: | Search function query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46607@lists.php.net to get a copy of this message | ||
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