Search code??

[Bickey]

This is my SEARCH code.

 

$like  = "SearchWord LIKE '%".implode("%' OR SearchWord LIKE '%", explode(' ', $Var))."%'";
$query = "SELECT * FROM db1 WHERE $like ORDER BY ToDate ASC";
$results = mysql_query($query);

 

Currently this code search every word in the MYSQL column. (e.g. If a user enter a 3 words and hit the search button, it still take the two words as individual words and outputs all records which has either of those 3 words.)

 

My need is to make the code find ALL the search words match in any sequence.

 

Example:

Wooden toy for 3 year old

Metal sward

Dora cotton pillow

Wooden sward

 

if the user search using "wooden toy" the code should show only "Wooden toy for 3 year old"

if the user search using "wooden" the code should show "Wooden sward" and  "Wooden toy for 3 year old"

 

 

[nethnet]

Just change the OR to AND.  This will return rows that match ALL of the criteria, instead of ANY of the criteria.