TP 逗号数据库逗号隔开与逗号隔开的条件匹配 if(!empty($select_id)){ $select_arr = explode(',',implode(',',$select_id)); foreach ($select_arr as $key => $value) { if($key == 0){ $where_str = 'find_in_set('.$value.',category)'; }else{ $where_str = $where_str.' and find_in_set('.$value.',category)'; } } } $newWhere = ' FIND_IN_SET("468", b.fangCharachteristic)';
Yii2多个关键字查询
$kw=explode(',',$data['keyword']);
foreach($kw as $k=>$v){ if($k==0){ $wheres[] = 'or'; $wheres[] = 'FIND_IN_SET(:id'.$k.',keyword)'; }else{ $wheres[] = 'FIND_IN_SET(:id'.$k.',keyword)'; } $wheress[':id'.$k] = $v; } $query->where( $wheres , $wheress); $query->asArray(); $datalike=$query->one(); echo $query->createCommand()->getRawSql();