sql select where like ( search help )

[listenmirndt]

$sql = "SELECT count(*) FROM $app$LISTINGS WHERE TITLE LIKE '%$_POST[search]%' OR SUMMARY LIKE '%$_POST[search]%'"; 

This works fine except for when somone enters more then one word... it tries to match the exact phrase.

I want to pull results from any words in a phrase, not the exact phrase - not quite sure how to go abouts accomplishing this.

Any help would be great
thanks
-Arron

[coreyp_1]

I'm not an expert on LIKE queries, but I would do this:
break the search string up into the different words (explode(' ', $searchstring) perhaps?).
loop through the array building the LIKE part of the query
add this to the main query

for instance, if someone searched for "hot fudge sundae", the LIKE string would be:
TITLE LIKE '%hot%' OR SUMMARY LIKE '%hot%' OR
TITLE LIKE '%fudge%' OR SUMMARY LIKE '%fudge%' OR
TITLE LIKE '%sundae%' OR SUMMARY LIKE '%sundae%'

may not be the best way, but it should get the job done.

[batman]

^ is what i was thinking..

$var = $_POST[search];
$string = explode(" ", $var);

$sql = "SELECT count(*) FROM $app$LISTINGS WHERE TITLE LIKE '$string[]' OR SUMMARY LIKE '$string[]'"; 

[toxic_brain]

U can follow coreyp_1's logic.. me too is using the same...