Where like laravel

Laravel orWhere

$camps = $field->camps()->where('status', 0)->where(function ($q) {
    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();

Source: laracasts.com

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

Add like and equal in same query in laravel

$data = DB::table('borrowers')
        ->join('loans', 'borrowers.id', '=', 'loans.borrower_id')
        ->select('borrowers.*', 'loans.*')   
        ->where('loan_officers', 'like', '%' . $officerId . '%')
        ->where('loans.maturity_date', '<', date("Y-m-d"))
        ->get();

Source: stackoverflow.com

Where like laravel

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

Source: laravel.com

Similar codes

0 vote264 views1 answer
Laravel api get controller
PHP Laravel
0 vote363 views1 answer
How run job laravel in cpanel host
PHP Laravel
0 vote336 views1 answer
Laravel resourece type
PHP Laravel
11 votes301 views5 answers
Laravel redirect back url with message
PHP Laravel
11 votes333 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
1 vote300 views2 answers
Laravel collection implode
PHP Laravel
9 votes281 views4 answers
Laravel route pattern
PHP Laravel
0 vote334 views1 answer
Detect mobile device laravel
PHP Laravel
0 vote339 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
1 vote333 views3 answers
Check image exist or not in laravel
PHP Laravel