how to use like operator with '%'-Wildcard in where function of Collection in Laravel 5.3

This returns a Collection instance:

$bookings = BookingOverview::all();

so you are no longer dealing with Eloquent (or SQL) when you get to the second statement

Do this instead:

$bookings = BookingOverview::where('bill_of_delivery', 'like', $request->get('bill_of_delivery') . '%')->get();

thanks for helping but the problem is that this field isn't in the used table. This field is in a joined table. I access this field via the model using follwing.

public function getBillOfDeliveryAttribute(){
        return $this->booking->bill_of_delivery;
    }

When I use BookingOverview::where I got an error that 'bill_of_delivery' is missing in my table.

@elbgoods that wasn't at all clear from your original post...

What is the relationship between Booking and BookingOverview?

relation is one Booking has meny BookingOverviews.

I just now solved it using query scopes. I have following scopes in my BookingOverview-Model

public function scopeBeginsWith($query, $field, $input)
    {
        if(!$input) return $query;
        return $query->where($field, 'like', $input . '%');
    }

    public function scopeWithBookings($query)
    {
        return $query->join('bookings', 'bookings.id', '=', 'bookings_oberview.booking_id');
    }

and use now

$bookings = BookingOverview::withBookings()
            ->beginsWith('bill_of_delivery', $request->get('bill_of_delivery', ''))
            ->get();

to get what I want.