thinkphp5.0.24多条件查询exp表达式错误

Question

if($keys['level']){
    $where['level'] = array('IN',$keys['level']);
}
if($keys['cardid']){
    $where['cardid'] = array('=',$keys['cardid']);
}
if($keys['name']){
    $where['name'] = array('like', $keys['name'].'%');
}
if($keys['tel']){
    $where['tel'] = array('exp','REGEXP \''."^[1][3456789][0-9]{9}$".'\'');
}
if($keys['area']){
    $where['area'] = array('exp','FIND_IN_SET(1000, area)');
}
$list = $model->where($where)->select();

$where['tel'] = array('exp','REGEXP \''."^[1][3456789][0-9]{9}$".'\'');
$where['area'] = array('exp','FIND_IN_SET(1000, area)');
都会报错，表达式错误：exp，多条件查询该怎么用exp

Answer 1

要用Db::raw()语法才行

$where[] = array('exp', Db::raw("FIND_IN_SET(1000, area)"));