laravel - 像查询生成器中的 Laravel

Question

我这里有个问题，我用查询生成器做了搜索，数据库状态栏是varchar，它是active，inactive，disable

这里的问题，如果我寻找活动状态，那么也会出现非活动状态

 $vendor  = DB::table('client_vendor as cv')
                        ->leftJoin('vendors as fv','fv.id','=','cv.vendor_id')
                        ->select('cv.*','fv.*','cv.status')
                        ->where('cv.status', 'LIKE', '%' . 'active' . '%')
                        ->get();

这里我可能不会更改数据库中的数据类型

标签： laravellaravel-5eloquent

Answer 1

尝试这个

 $vendor  = DB::table('client_vendor as cv')
                        ->leftJoin('vendors as fv','fv.id','=','cv.vendor_id')
                        ->where('cv.status','=','active')
                        ->get();

编辑

$vendor  = DB::table('client_vendor as cv')
                        ->join('vendors as fv','fv.id','=','cv.vendor_id')
                        ->select('cv.*','fv.*')
                        ->where('cv.status','active')  // or  ->where('cv.status','=','active')
                        ->get();