有些时候我们需要搜索某些东西,需要用到一个字段多个模糊值进行搜索,例如:张,李,王这样的组合条件来模糊查询相关数据集
$search = '张,李,王';
$search_arr = explode(',',str_replace(',',',',$search));
foreach ($search_arr as $vo){
$likes[] = '%'.$vo.'%';
}
$where = [
['title','like',$likes,'or'],
['status','=',1]
];
$data = Db::name('tables')->where($where)->select();