mysql php选择一条与另一个相似的记录

试试这个：

function getProductos($keyWords) {     $keyWordsExploded = explode(" ",$keyWords);      $sql = "SELECt * FROM PRODUCTOS WHERe ";      $likes = array("HOMBRE_MUJER", "CATEGORIA", "NOMBRE"); // build up our columns which will be used in our condition in sql statment      $params = array();      // building up our sql statment and collecting our params      foreach($likes as $like) {        foreach($keyWordsExploded as $kw) {          $sql .="$like like ? or ";          $params[] = "%".$kw."%";        }      }     $sql = rtrim($sql, "or "); // trim the last "or" condition in sql statment     $query = self::$conn->prepare($sql);     $query->execute($params);     return $query;}