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();