Laravel eloquent model query for `not null`

Question

I've been using Laravel for a project and using the Eloquent models to grab the model instances I need.

However, it doesn't look like there's a way to query for not null values.

Is there a way to do something like this, where I want to get all Flight models where the ticket_id is not null?

$flight = App\Flight::where('ticket_id', '!=', null);

A.khalifa · Accepted Answer · 2017-06-17 00:26:22Z

27

Try this

$flight = App\Flight::whereNotNull('ticket_id')->get();

user320487

answered Jun 17, 2017 at 0:24

A.khalifa

2,5063 gold badges31 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thks a lot, u saved me