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

12 votes369 views4 answers
Laravel return redirect to named route
PHP Laravel
0 vote370 views1 answer
Laravel check if request wantsjson
PHP Laravel
9 votes355 views4 answers
Laravel time format
PHP Laravel
0 vote352 views1 answer
Trait 'laravel\sanctum\HasApiTokens' not found laravel 7
PHP Laravel
0 vote392 views1 answer
Diffforhumans laravel
PHP Laravel
0 vote363 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote395 views1 answer
Curl error (code 3) url malformed laravel
PHP Laravel
15 votes341 views6 answers
Laravel create request
PHP Laravel
51 votes466 views6 answers
Create model with controller laravel
PHP Laravel
0 vote355 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel