Where query column if column has value

Do you mean if $date is null?

trips()->with('user', 'a_point', 'b_point')
                                    ->where('date_from', '>=' , Carbon::today())
                                    ->where('date_from', '>=' , Carbon::parse($date)->format('Y-m-d'))
                                    ->when($date, function($query, $date) {
                                        $query->where( function ( $subQuery ) use ( $date ) {
                                            $subQuery->whereNotNull( 'date_to' )
                                                  ->orWhere('date_to', '<=' , Carbon::parse($date)->format('Y-m-d'));
                                            });
                                    });

@sinnbeck nope $date will come from request, I mean make query depending upon date_to column value in the table. Is it possible?

You use same date for date_from and date_to that's problem.

It's same as

$date = Carbon::parse($request->date)->toDateString();

->where('date_from', $date)->where('date_to', $date)

@michaloravec i want to make query where $date greater than date_from and lower than date_to, but date_to sometimes null, in this case query should return only $date greater than date_from

@dosmukhanbet So your logic is opposite, you have problem with <= and >=

$date = Carbon::parse($request->date)->toDateString();

trips()->with('user', 'a_point', 'b_point')->where('date_from', '<=', $date)->where(function ($query) use ($date) {
    $query->where(function ($query) use ($date) {
        $query->whereNotNull('date_to')->where('date_to', '>=', $date);
    })->orWhereNull('date_to');
});