YII2 模糊查询怎么做

Question

YII2 模糊查询怎么做

Answer 1

$rows = (new \yii\db\Query())->from('admin')->where("status=:status and (username like :keyword or `name` like :keyword )")->addParams([':status'=>1,':keyword'=>'%陈%'])->all();