[PHP-DB] Search function query

[Ron Piggott]

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