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   - gt     but it gives IS NOT as a binding instead of a comparison   This is what DB  getQueryLog   says about it      query    gt  string  select   from my table where sent at     and profile id in        order by created at desc   length 101     bindings    gt       array  size 3        0   gt  string  IS NOT   length 6        1   gt  int 1       2   gt  int 4

User · Answer

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', '<>', '');
}

User · Answer

I see this question is a bit old but I ran across it looking for an answer   Although I did not have success with the answers here I think this might be because I m on PHP 7 2 and Laravel 5 7  or possible because I was just playing around with some data on the CLI using Laravel Tinker     I have some things I tried that worked for me and others that did not that I hope will help others out   I did not have success running       MyModel  whereNotNull  deleted by  - gt get  - gt all                          MyModel  where  deleted by     lt  gt    null - gt get  - gt all                     MyModel  where  deleted by         null - gt get  - gt all                     MyModel  where  deleted by     lt  gt         and  - gt get  - gt all                MyModel  where  deleted by     lt  gt    null   and  - gt get  - gt all              MyModel  where  deleted by    IS NOT   null - gt get  - gt all               All of the above returned an empty array for me  I did however have success running       DB  table  my models  - gt whereNotNull  deleted by  - gt get  - gt all                 This returned all the results in an array as I expected   Note  you can drop the all   and get back a Illuminate Database Eloquent Collection instead of an array if you prefer

User · Answer

in laravel 5 4 this code Model  whereNotNull  column   was not working you need to add get   like this one Model  whereNotNull  column  - gt get    this one works fine for me

User · Answer

If you wanted to use the DB facade   DB  table  table name  - gt whereNotNull  sent at  - gt get

User · Answer

Eloquent has a method for that  Laravel 4   5      Model  whereNotNull  sent at     Laravel 3   Model  where not null  sent at

User · Answer

If you want to search deleted record  Soft Deleted Record   do t user Eloquent Model Query  Instead use Db  table query e g Instead of using Below    stu   Student  where  rollNum         rollNum    -     nursery - gt first      Use    stu   DB  table  students  - gt where  rollNum         newRollNo - gt first

User · Answer

We can use  Model  whereNotNull  sent at      Or  Model  whereRaw  sent at is not null

[laravel] How do you check "if not null" with Eloquent?

Examples related to laravel

Examples related to eloquent