更多查看 [鏈式操作](http://www.hmoore.net/a173512/thinkphp6/2452932) [查詢表達式](http://www.hmoore.net/a173512/thinkphp6/2452933) ## **where** 表達式查詢是官方推薦使用的查詢方式 ~~~ //注意使用字符串查詢條件(不推薦) ：SELECT * FROM think_user WHERE type=1 AND status=1 Db::table('think_user')->whereRaw('type=1 AND status=1')->select(); //字符串查詢條件預處理 Db::table('think_user') ->whereRaw("id=:id and username=:name", ['id' => 1 , 'name' => 'thinkphp']) ->select(); //SELECT * FROM think_user WHERE `name`='thinkphp' AND id > 1 Db::table('think_user') ->where('id','>',1) ->where('name','thinkphp') ->select(); //等值 and條件 傳入數組作為查詢條件：SELECT * FROM think_user WHERE `name`='thinkphp' AND status = 1 Db::table('think_user')->where([ 'name' => 'thinkphp', 'status'=> 1 ])->select(); //索引數組條件查詢（推薦） // 傳入數組作為查詢條件 Db::table('think_user')->where([ ['name','=','thinkphp'], ['status','=',1] ])->select(); //數組條件 $map['name'] = 'thinkphp';//普通查詢 $map['status'] = 1;//普通查詢 $map['id'] = ['>',1];//使用查詢表達式 $map['mail'] = ['like','%thinkphp@qq.com%'];//使用查詢表達式 Db::table('think_user')->where($map)->select(); ~~~