php / mysql搜索查询字符串

Question

i'm trying to search terms that may or may not have a space... ex term: iPod Black 30. the results would be everything except, "ipod black used 30" and "used". so basically its finding all complete matching terms individual matching terms and skipping over any entry that may match but has a non-match word in it and of course the entry where nothing matches.

table:
prod
-- ipod black 30
-- ipod 30
-- ipod black used 30

types
-- ipod
-- 30
-- black
-- used

Answer 1

Break you search term into individual strings. Then use the individual strings in your query for an exact match across the tables.

Sample Code:

$terms = array();
$terms = explode(" ",$searchstr);

$sql = "select fields from tables where";

$first = true;

foreach($terms as $term)
{

  if(!$first) $sql .= " OR "

  $sql .= "fieldA like ('%".trim($term)."%')";

  $first = false;

}

// execute query!