eloquent_tips_laravel.php

--Simple Where
Model::where('field', '*operator', 'value').
//*operator = "< , >, =, =>, =< etc"

-- Between where
Model::whereBetween('field',['value1', 'value2']);
  
-- Raw Where for exclusive treatments
  Model::whereRaw('LEFT(field, 4) = tesssttteeee')
  
  //Left JOin
   Model:leftJoin('table', 'table.id', '=', 'Model id')
  
  //If in where
  ->when($filter, function($q) {
                                       return $q->where("field", '=', 0);
                                    })