<?php

 #DB 高级查询

 // select * from table where A and B or C

 $all_data = DB::table("shopnc_goods_common")

     ->where("base_goods_commonid", -1)

     ->where('goods_name', 'like', '%' . $keywords . '%')

     ->orWhere('goods_jingle', 'like', '%' . $keywords . '%')

     ->select("goods_commonid")->get();

 // select * from table A and B

 $users = DB::table('users')

     ->whereColumn([

         ['first_name', '=', 'last_name'],

         ['updated_at', '>', 'created_at']

     ])->get();

 // select * from table A and ( B or C )

 $all_data = DB::table("shopnc_goods_common")

     ->where("base_goods_commonid", -1)

     ->where(function ($query) use ($keywords) {  //闭包

         $query->where('goods_name', 'like', '%' . $keywords . '%')

             ->orWhere('goods_jingle', 'like', '%' . $keywords . '%');

     })

     ->select("goods_commonid")->get();