SELECT * FROM `tp_finance` WHERE `subject` = '生產費用' AND `project` = '主料' OR `subject` = '生產費用' OR `project` = '材料運費' ``` Db::name('finance') ->where([['subject','=','生產費用'],['project','=','主料']]) ->whereOr([['subject','=','生產費用'],['project','=','材料運費']]) ->select(); ``` **注意，相同的字段的多次查詢條件可能會合并，如果希望某一個`where`方法里面的條件單獨處理，可以使用下面的方式，避免被其它條件影響。** SELECT * FROM `think_user` WHERE ( `name` LIKE 'thinkphp%' AND `title` LIKE '%thinkphp' AND `id` > 0 ) AND `status` = '1' ~~~ $map = [ ['name', 'like', 'thinkphp%'], ['title', 'like', '%thinkphp'], ['id', '>', 0], ]; Db::table('think_user') ->where([ $map ]) ->where('status',1) ->select(); ~~~ **在多個字段之間用`|`分割表示`OR`查詢，用`&`分割表示`AND`查詢** SELECT * FROM `think_user` WHERE ( `name` LIKE 'thinkphp%' OR `title` LIKE 'thinkphp%' ) AND ( `create_time` > 0 AND `update_time` > 0 ) LIMIT 1 ~~~ Db::table('think_user') ->where('name|title','like','thinkphp%') ->where('create_time&update_time','>',0) ->find(); ~~~ SELECT * FROM `think_user` WHERE ( `name` LIKE 'thinkphp%' AND `title` LIKE '%thinkphp' ) OR ( `name` LIKE 'kancloud%' AND `title` LIKE '%kancloud' ) ~~~ $map1 = [ ['name', 'like', 'thinkphp%'], ['title', 'like', '%thinkphp'], ]; $map2 = [ ['name', 'like', 'kancloud%'], ['title', 'like', '%kancloud'], ]; Db::table('think_user') ->whereOr([ $map1, $map2 ]) ->select(); ~~~ ## **閉包查詢WHERE(function)** **每個閉包條件兩邊也會自動加上括號** SELECT * FROM `think_user` WHERE ( `name` = 'thinkphp' OR `id` > 10 ) ~~~ $name = 'thinkphp'; $id = 10; Db::table('think_user')->where(function ($query) use($name, $id) { $query->where('name', $name) ->whereOr('id', '>', $id); })->select(); ~~~ SELECT * FROM `think_user` WHERE `name` LIKE 'thinkphp%' AND ( `id` < 10 ) ~~~ Db::table('think_user') ->where('name', 'like', 'thinkphp%') ->where(function ($query) { $query->where('id', '<', 10); }) ->select(); ~~~ ## **whereRaw:原生SQL語句進行查詢** 對于一些實在復雜的查詢，也可以直接使用原生SQL語句進行查詢，例如： ~~~ Db::table('think_user') ->whereRaw('id > 0 AND name LIKE "thinkphp%"') ->select(); ~~~ 為了安全起見，我們可以對字符串查詢條件使用參數綁定，例如： ~~~ Db::table('think_user') ->whereRaw('id > :id AND name LIKE :name ', ['id' => 0, 'name' => 'thinkphp%']) ->select(); ~~~