How to use Where null and Where not null eloquent query in Laravel?
Where Null Query
DB::table('users')->whereNull('name')->get();
Where Not Null Query
DB::table('users')->whereNotNull('name')->get();
Laravel print query
use Illuminate\Support\Facades\DB; DB::enableQueryLog(); //$results_rebates = \DB::select( DB::raw("SELECT count(id) as count_rebates FROM campaigns as c WHERE ((c.daily_rebates) - (select count(id) from user_rebate_apply where campaigns_id = c.id )) > 0 AND (c.end_date >= NOW())") ); //$query = \DB::getQueryLog();