Problems forming compound query

[studio64]

I have a database of product's with descriptions and I'd like to be able to search the database from a user input (i.e. generic search box).

The code is fairly simple for a query with only one word in it.
SELECT* FROM product WHERE (Descrip LIKE '%$word%')

but, when the query is longer than one word, obviously the previous statement doesn't scale properly when more than one word is entered.

Is there a more appropriate query to use in this case?

[sfullman]

you can tell the user to enter commas after each word, and if you detect this you can do this

if(preg_match('/[^{,]+(,[,]+)+/',} $word)){
$wordArray = explode(',',$word);
foreach($wordArray as $n=>$v){
$wordString .= "'%" . trim($v) . "%', ";

 }  
 // clean end
 $wordString = "(" . substr($wordString, 0, strlen($wordString)-2) . ")";

}

$whereClause = "Where Field IN " . $wordString;

//will produce "where Field IN ('%cow%', '%horse%', '%giraffe%')"

There are other ways of approaching this, any one of which could be very complex, generally you need to give some simple instructions to the client to use your algorithm.

Sam