Yii2 查询条件使用总结。
Model::find()
//第一种:等于和模糊
->Where(['=', 'status',10]) ->andWhere(['like', 'title','yii']) # WHERE (`status` = 10) AND (`title` LIKE '%yii%')
//第二种:并列等于
->Where(['and', 'id=1', 'name=2']) # WHERE id=1 AND name=2
//第三种:并列或,并列与
->Where(['and', 'type=1', ['or', 'id=1', 'id=2']]) # WHERE type=1 AND (id=1 OR id=2)
//第四种:并列或模糊
->Where(['or like','name',['哈哈','苦苦']]); # WHERE `name` LIKE '%哈哈%' OR `name` LIKE '%苦苦%'
//第五种:并列模糊,并列与
->Where(['or',['like','name','哈哈'],['like','title','苦苦']]) # WHERE (`status`=1) AND ((`name` LIKE '%哈哈%') OR (`title` LIKE '%苦苦%'))
//第六种:小于等于
->Where(['<=', 'id', 8]) # WHERE id<=8
//第七种:between
->andWhere(['between','updated_at','2023-2-6 15:23:10', '2024-2-6 15:23:10']) #where updated_at between ('2023-2-6 15:23:10', '2024-2-6 15:23:10')