mysql split search string by space and push into query

[Unilleseeva]

The search query is: "product1 prod2 prod4"I need to make the mysql\[code\]SELECT * FROM tableprod WHERE (prod LIKE '%product1%' AND prod LIKE '%prod2%' AND prod LIKE '%prod4%')\[/code\]using the mysql_real_escape_string for the input query...