database search requiring full match
I have setup a products database that has different product lines with similar named products. i.e. Line 1, product "wash"; Line 2, product "wash" etc. I have setup search / result pages to query the DB but if some one types in "Line 1 wash" they get all of the products that contain wash and I want the results to require a match on the entire search string. Any product that contains both "line 1" and "wash". I have attached both a page with the search form and the results page. Thank you.