yii2.0多条件查询

1.一个字段模糊擦查询

var $username='张三';var $email ='qq@qq.com';var $mobile =18888888888;$result=User::find()->where(['status'=>1,])->andwhere(['or',['like','username',$username],['like','email',$email],['like','mobile',$mobile],])->all();

2.多个字段模糊查询

//->where("a.goods_name like :goods_name")
//->addParams([':goods_name'=>'%'.$goods_name.'%'])