RE: [PHP] How to search products on my site

[snip] I have a site with some phone products. I want to search for a specific products. I use this: SELECT product_id, product_name FROM products WHERE product_name LIKE '%$search_string%' It works fine if the search string counts 1 word. But if the search string id counts 2 or 3 or more words it's not working.. How can i do this kind of search. I do not want a boolean search or a fulltext search. [/snip] If you don't want to do fulltext or boolean then you may have to construct your query with several OR statements based on the number of words entered into the search criteria.