如何通过匹配存储在表列中的字符串中的单个单词来查找数据库中的数据-解网

问：

这是从表中查找地址的查询，其中它与变量，$fromCity

$fromCity= "324 West Gore Street, Orlando, FL 32806, USA";
$sql = "SELECT * FROM vendor_info WHERE mailing_address LIKE '$fromCity'";
$em = $this->getDoctrine()->getManager();
$stmt = $em->getConnection()->prepare($sql);
$stmt->execute();
$company = $stmt->fetchAll();
dd($company);

在表中，列如下所示vendor_infomailing address324 WEST GORE STREETORLANDO, FL 32806

如果任何一个单词与列匹配，我想得到结果mailing_address

现在的结果是空数组，dd(company);

请帮我找出这个解决方案，它是在symfony中，

php mysql symfony 搜索类SQL

   $fromCity = "324 West Gore Street, Orlando, FL 32806";
   $fromCity_arr = explode(', ', $fromCity);
   $whereStr = '';
   foreach($fromCity_arr as $fromCity_el){
     if(!empty($whereStr)){$whereStr .= " AND ";}
     $whereStr .= "mailing_address LIKE '%".$fromCity_el."%'";
   }
   $sql = "SELECT * FROM vendor_info WHERE $whereStr";
   ......

结果：

SELECT 
 * 
FROM 
  vendor_info 
WHERE 
  mailing_address LIKE '%324 West Gore Street%' 
 AND 
  mailing_address LIKE '%Orlando%' 
 AND 
  mailing_address LIKE '%FL 32806%'

$fromCity = "324 West Gore Street, Orlando, FL 32806";
$fromCity_arr = explode(', ', $fromCity);
$stm = $this->getEntityManager()->getRepository(MyModel::class)->getQueryBuilder('a');
for($i=0;$i<count($fromCity_arr);$i++) {
    $stm->andWhere('a.mailing_address like ?)
        ->setParameter($i+1, '%'.$fromCity_arr[$i].'%'); 
}

$result = $stm->getQuery()->getResult();
dump($stm->getQuery()->getSql());
dd($result);

上一个：希望通过从数据库对象获取来返回 Json 格式的数据。Php 交响乐

下一个：在 laravel 中从外部 API 搜索特定数据

如何通过匹配存储在表列中的字符串中的单个单词来查找数据库中的数据

how to find data from database by matching single word in a string stored in table's column

评论

评论