PHP mysql查询判断不回显重复部分

Question

我想进行 php 搜索查询。首先，我放一个句子并分解每个单词得到 $name，然后我把 $name 进行查询以匹配我数据库中存在的所有名称。然后 echo 部分 $row['name'][$i] 有一些单词重复。

例如:句子是:Marc Gasol is brother of Pau Gasol and Gasol 在我的数据库中，所以匹配词Gasol珍珠 2 次。如何echo $row['name'][$i]; 并且只得到一个Gasol？谢谢，

$query = mysql_query("SELECT * FROM books WHERE name like '$name[0]' OR name like '$name[1]' OR name like '$name[2]' OR name like '$name[3]' "); 
$i = 0;
while($row = mysql_fetch_array($query)) {     
echo $row['name'][$i];     
$i++; 
}       

Answer 1

$sentence = "Marc Gasol is the brother of Pau Gasol";
$words = preg_split("/\s+/", $sentence);

//this will uniqueify your value set
$uniqueWords = array_keys(array_flip($words));

foreach($uniqueWords as $word){
    $parts[] = "name like '%".mysql_real_escape_string($word)."%'";  
}

$where = implode(" OR ", $parts);




$query = mysql_query("SELECT * FROM books WHERE $where "); 
$i = 0;
while($row = mysql_fetch_array($query)) {     
echo $row['name'][$i];     
$i++; 
}