How do you check "if not null" with Eloquent?

Question

How do you check if a field is not null with Eloquent?

I tried Model::where('sent_at', 'IS NOT', DB::raw('null'))->... but it gives IS NOT as a binding instead of a comparison.

This is what DB::getQueryLog() says about it:

  'query' => string 'select * from my_table where sent_at = ? and profile_id in (?, ?) order by created_at desc' (length=101)   'bindings' =>      array (size=3)       0 => string 'IS NOT' (length=6)       1 => int 1       2 => int 4 

Answer 1

Eloquent has a method for that (Laravel 4.*/5.*);

Model::whereNotNull('sent_at') 

Laravel 3:

Model::where_not_null('sent_at') 

Answer 2

If someone like me want to do it with query builder in Laravel 5.2.23 it can be done like ->

 $searchResultQuery = Users::query();   $searchResultQuery->where('status_message', '<>', '', 'and'); // is not null  $searchResultQuery->where('is_deleted', 'IS NULL', null, 'and'); // is null  

Or with scope in model :

public function scopeNotNullOnly($query){      return $query->where('status_message', '<>', ''); }