public static function listOfCategory($val) { $query = PartsCategory::select('id', 'parts_category'); if (strlen(trim($val)) > 0) { $query = $query->where('parts_category', 'LIKE', '%' . str_replace(' ', '%', $val) . '%'); } $query = $query->orderBy('parts_category')->get(); return $query; }