$query->where('pages_count', '<', 200)->orWhere('description', '=', '');
})->get();
return $results;
});
Route::get('book_get_whereBetween', function () {
$results = \App\Book::whereBetween('pages_count', [170, 200])->get();
return $results;
});
// Return all results that have title that exist in this array
Route::get('book_get_whereIn', function () {
$results = \App\Book::whereIn('title', ['My Third Book!', 'My Second Book!'])->get();
return $results;
});
// Fetching all records with the where clause in conjunction with a column Name a.k.a magic Where
Route::get('book_get_whereColumnName', function () {
$results = \App\Book::whereTitle('My Fourth Book!')->get();
return $results;
});
// Return all books that dont exist. .ie books that have the title column as NULL
Route::get('book_get_whereNull', function () {
$results = \App\Book::whereNull('title')->get();
return $results;
});
/**
* AGGREGATES
*/
// Get the number of books in the database
Route::get('book_get_books_count', function () {
$booksCount = \App\Book::count();
return $booksCount;
});
