Laravel where not

Laravel where like

$users = DB::table('users')
                ->where('name', 'like', 'T%')
                ->get();

Source: laravel.com

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Where like laravel

User::query()
   ->where('name', 'LIKE', "%{$searchTerm}%") 
   ->orWhere('email', 'LIKE', "%{$searchTerm}%") 
   ->get();

reference:
https://freek.dev/1182-searching-models-using-a-where-like-query-in-laravel

Laravel where not

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: stackoverflow.com

Similar codes

0 vote321 views1 answer
Send emails with runtime configurations in laravelk
PHP Laravel
3 votes294 views2 answers
Create .env file in laravel with cmd
PHP Laravel
0 vote294 views1 answer
Laravel Password & Password_Confirmation Validation
PHP Laravel
0 vote313 views1 answer
Laravel faker select between options
PHP Laravel
3 votes311 views1 answer
Laravel loop through collection
PHP Laravel
2 votes287 views2 answers
Check if date between two dates laravel
PHP Laravel
1 vote301 views6 answers
Laravel get url parameters in controller
PHP Laravel
2 votes302 views1 answer
Laravel artisan create criteria
PHP Laravel
0 vote253 views1 answer
Laravel collection forPage
PHP Laravel
1 vote312 views3 answers
Laravel model to array
PHP Laravel