著作权归作者所有。
商业转载请联系作者获得授权，非商业转载请注明出处。
本文链接：https://www.yaanbbs.net/forum.php?mod=viewthread&tid=30113&highlight=laravel
来源：雅安论坛(www.yaanbbs.net)

laravelDB类之查询

满足条件的全部获取：DB::table("表名")->where("name",">","1")->get();
满足条件的第一列获取：DB::table("表名")->where("name",">","1")->first();
满足条件的全部字段：DB::table("表名")->where("name",">","1")->lists("title");
满足条件的单一字段：DB::table("表名")->where("name",">","1")->pluck("title");//返回二位字段值数组
　　                             DB::table("表名")->where("name",">","1")->pluck("title","name");//返回二位字段值数组 第二个参数指定key
分块查询数据列：DB::table("表名")->chunk(100,function($users){
//$users to do $user是table中2行一次查询的结果
//return false; 停止处理接下来的数据
})
指定查询字句：DB::table("表名")->select("name","email")->get();
增加查询子句到已有查询中：$query=DB::table("表名")->select("name","email");$query->addSelect("age")->get();
条件查询where和orWhere：DB::table("表名")->where("name",">","10")->orWhere("titile","=","0")->get();
条件查询whereBetween和whereNotBetween：DB::table("表名")->where("name",">","10")->whereBetween("titile","=","[0,10]")->get();
条件查询whereIn：DB::table("表名")->where("name",">","10")->whereIn("titile","[1,2,3]")->get();
条件查询whereNull：DB::table("表名")->where("name",">","10")->whereNull("titile")->get();//未配置的值
条件查询where Clauses：DB::table("表名")->where("name",">","10")->whereNameAndTitle("name",titile")->get()；
排序（Drder By）,分群（Group By）及 Having:
$users=DB::table("users")->orderBy("name","desc")->groupBy("count")->having("count",">",100)->get()
偏移（Offset）及 限制 （Limit）
$users=DB::table("users")->skip(10)->take(5)->get();