Urgent! How to seperate and query?

[Manat]

If I have a search tool on my extranet with this query:

{$get_entries = mysql_query("SELECT keywords.*, Product.*, Price.* FROM keywords, Price, Product WHERE keywords.keyword LIKE '%$word%' AND keywords.sku = Product.SKU  AND Produit.Price = Price.Price AND Product.Is_Active=1 ORDER BY keywords.sku, pertinance DESC LIMIT $limitvalue, $limit") or die(mysql_error()); }

It works fine, but if I type a keyword like black stone, and black is a keyword belonging to one product, and stone belonging to another product, how do I seperate the two words?

I guess whenever there is whitespace, seperate the two variables and query based on both???????

Can someone please tell me how I would edit the SQL?

I would greatly apreciate any help.

Thanks
MK

[devinemke]

$words = explode(' ', $word);
mysql_query("SELECT keywords.*, Product.*, Price.* FROM keywords, Price, Product WHERE keywords.keyword REGEXP '" . implode('|', $words) . "' AND keywords.sku = Product.SKU  AND Produit.Price = Price.Price AND Product.Is_Active=1 ORDER BY keywords.sku, pertinance DESC LIMIT $limitvalue, $limit");