Answered by : lokesh-ramchandani-in6l3jq294i2
User::query() ->where('name', 'LIKE', "%{$searchTerm}%") ->orWhere('email', 'LIKE', "%{$searchTerm}%") ->get();
reference:
https://freek.dev/1182-searching-models-using-a-where-like-query-in-laravelSource : | Last Update : Sat, 26 Dec 20
Answered by : adams-paul
$q->whereDate('created_at', '=', date('Y-m-d'));Source : https://stackoverflow.com/questions/33247908/get-only-records-created-today-in-laravel | Last Update : Sat, 18 Jul 20
Answered by : hassan-joseph
$camps = $field->camps()->where('status', 0)->where(function ($q) { $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();Source : https://laracasts.com/discuss/channels/eloquent/use-orwhere-in-eloquent | Last Update : Tue, 27 Oct 20
Answered by : lokesh-ramchandani-in6l3jq294i2
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();Source : | Last Update : Sat, 03 Oct 20
Answered by : itchy-iguana-axpt8sq1aduz
User::whereDate('created_at', date('Y-m-d'));
User::whereDay('created_at', date('d'));
User::whereMonth('created_at', date('m'));
User::whereYear('created_at', date('Y'));Source : https://laravel-news.com/eloquent-tips-tricks | Last Update : Fri, 23 Sep 22
Answered by :
Book::where('title', 'like', '%'.$this->search.'%')->get()Source : https://stackoverflow.com/questions/30761950/laravel-5-like-equivalent-eloquent | Last Update : Fri, 04 Mar 22
Answered by : itchy-iguana-axpt8sq1aduz
// whereRaw
$orders = DB::table('orders') ->whereRaw('price > IF(state = "TX", ?, 100)', [200]) ->get();
// havingRaw
Product::groupBy('category_id')->havingRaw('COUNT(*) > 1')->get();
// orderByRaw
User::where('created_at', '>', '2016-01-01') ->orderByRaw('(updated_at - created_at) desc') ->get();Source : https://laravel-news.com/eloquent-tips-tricks | Last Update : Fri, 23 Sep 22