#標準寫法$stat_book_list = BookSaleChangeLog::find() ->select( [ 'book_id','SUM(quantity) AS total_count','SUM(price) AS total_pay_money' ] ) ->andWhere([ 'between','created_time',$time_start,$time_end ]) ->groupBy('book_id')->asArray()->all();$query = Project::find()->where(['dept_id'=>$dept_id])->all();#寫完之后一定要加上one()或者是all()#對比 ['>', 'id', 1] // 生成：id > 1 ['<', 'id', 100] // 生成：id < 100 ['=', 'id', 10] // 生成：id = 10 ['>=', 'id', 1] // 生成：id >= 1 ['<=', 'id', 100] // 生成：id <= 100 ['!=', 'id', 10] // 生成：id != 10#并聯 ['and', 'id' => 1, 'id' => 2] // 生成：id=1 AND id=2 ['and', 'id=1', 'id=2'] // 生成：id=1 AND id=2 ['and', 'type=1', ['or', 'id=1', 'id=2']] // 生成：type=1 AND (id=1 OR id=2)#OR ['or', ['type' => [7, 8, 9]], ['id' => [1, 2, 3]]] // 生成：(type IN (7, 8, 9) OR (id IN (1, 2, 3)))#NOT ['not', ['attribute' => null]] // 生成：NOT (attribute IS NULL)#between ['between', 'id', 1, 10] // 生成：id BETWEEN 1 AND 10 ['not between', 'id', 1, 10] // 生成：id NOT BETWEEN 1 AND 10#IN ['in', 'id', [1, 2, 3]] // 生成：id IN (1, 2, 3) ['id' => [4, 8, 15]] // 生成：id IN (4, 8, 15) ['not in', 'id', [1, 2, 3]] // 生成：id NOT IN (1, 2, 3) ['in', ['id', 'name'], [['id' => 1, 'name' => 'foo'], ['id' => 2, 'name' => 'bar']]] // 生成：(`id`, `name`) IN ((1, 'foo'), (2, 'bar'))#子查詢 #用子查詢作為IN條件的值 ['in', 'user_id', (new Query())->select('id')->from('users')->where(['active' => 1])]#模糊查詢 ['like', 'name', 'tester'] // 生成：name LIKE '%tester%'['like', 'name', ['test', 'sample']] // 生成：name LIKE '%test%' AND name LIKE '%sample%'['like', 'name', '%tester', false] // 生成：name LIKE '%tester' 這是自定義查詢方式，要傳入值為false的運算數3，并且自行添加%['or like', 'name', ['test', 'sample']] // 生成：name LIKE '%test%' OR name LIKE '%sample%'['not like', 'name', 'tester'] // 生成：name NOT LIKE '%tester%'['or not like', 'name', ['test', 'sample']] // 生成：name NOT LIKE '%test%' OR name NOT LIKE '%sample%'['exists', (new Query())->select('id')->from('users')->where(['active' => 1])] // 生成：EXISTS (SELECT "id" FROM "users" WHERE "active"=1)

?

總結

以上是生活随笔為你收集整理的Yii的Where条件的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。