How to check column value of a record is null or not in laravel

You can check if the column value of a record is null or not in laravel using whereNotNull() and exists() method. exists() method returns false if the column value of a record in the table is null and it returns true if column value is not null.

Answers 1
  • Laravel whereNotNull() with exists() method to check if the column value is null or not

    $hasImage = User::where('id', Auth::user()->id)->whereNotNull('image')->exists();
    dd($hasImage);
    
    0

    Output :

    true

    or 

    false

    It returns true if record  does not have null value in column and return false if record have null value in column.

  • Back to code snippet queries related laravel