PHP MYSQL布尔型全文本搜索

我发现布尔全文本搜索非常有用，但是由于某些原因，我无法弄清楚为什么我无法从查询中得到结果。

我的查询如下：

if(isset($_REQUEST['fname']) and $_REQUEST['fname']!=""){ $condition .= ' AND MATCH (fname, lname, mname) AGAINST('.(+$_REQUEST['fname']).' IN BOOLEAN MODE) ' ; } 该功能支持哪个功能；

public function get($tableName, $whereAnd = array(), $whereOr = array(), $whereLike = array()) { $cond = ''; $s=1; $params = array(); foreach($whereAnd as $key => $val) { $cond .= " And ".$key." = :a".$s; $params['a'.$s] = $val; $s++; } foreach($whereOr as $key => $val) { $cond .= " OR ".$key." = :a".$s; $params['a'.$s] = $val; $s++; } foreach($whereLike as $key => $val) { $cond .= " OR ".$key." like '% :a".$s."%'"; $params['a'.$s] = $val; $s++; } $stmt = $this->pdo->prepare("SELECT $tableName.* FROM $tableName WHERE 1 ".$cond); try { $stmt->execute($params); $res = $stmt->fetchAll();

    if (! $res || count($res) != 1) {
       return $res;
    }
    return $res;
} catch (\PDOException $e) {
    throw new \RuntimeException("[".$e->getCode()."] : ". $e->getMessage());
}

}

public function getAllRecords($tableName, $fields='*', $cond='', $orderBy='', $limit='') { //echo "SELECT $tableName.$fields FROM $tableName WHERE 1 ".$cond." ".$orderBy." ".$limit; //print "
SELECT $fields FROM $tableName WHERE 1 ".$cond." ".$orderBy." ".$limit; $stmt = $this->pdo->prepare("SELECT $fields FROM $tableName WHERE 1 ".$cond." ".$orderBy." ".$limit); //print "SELECT $fields FROM $tableName WHERE 1 ".$cond." ".$orderBy." " ; $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); return $rows; } 然后是搜索字段：

但是当我进行搜索时，无论是fname一个人还是一个人，都没有结果fname+lname。

问题来源于stack overflow