how to filter a table using row value=NULL in laravel controller

Question

   public function complaint_pending(){

    $complaints = Complaint::whereNull('answear')->get();

    return view('admin.complaint.panding',compact('complaints'));

   }

I want to show Complaint all data which answer row is NULL

My DB pic is below

enter image description here

Answer 1

you have type error in function.

change answear to answer in complaint_pending method.

Answer 2

That's not work but it's work perfectly ...

  public function complaint_pending(){
    
    $complaints = Complaint::where('answear', NULL)->get();
    
    return view('admin.complaint.panding',compact('complaints'));
    }