Question : where like laravel
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
Question : whereNot in in laravel 8
Answered by : lokesh-ramchandani-in6l3jq294i2
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();Source : | Last Update : Sat, 03 Oct 20
Question : laravel where like
Answered by : alberto-peripolli
$users = DB::table('users') ->where('name', 'like', 'T%') ->get();Source : https://laravel.com/docs/7.x/queries | Last Update : Wed, 20 May 20
Question : laravel where not
Answered by : purple-team
Code::where('to_be_used_by_user_id', '<>' , 2)->get()
Code::whereNotIn('to_be_used_by_user_id', [2])->get()
Code::where('to_be_used_by_user_id', 'NOT IN', 2)->get()Source : https://stackoverflow.com/questions/28256933/eloquent-where-not-equal-to | Last Update : Thu, 10 Feb 22