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

1 vote237 views1 answer
Laravel validate enum field
PHP Laravel
29 votes269 views3 answers
Seed date laravel
PHP Laravel
0 vote253 views1 answer
Italic text in laravel notification
PHP Laravel
17 votes287 views3 answers
Laravel order by desc
PHP Laravel
12 votes268 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
0 vote229 views1 answer
Laravel include files
PHP Laravel
1 vote249 views2 answers
Database//Eloquent//Model.php laravel errror array t- string conversion
PHP Laravel
1 vote320 views2 answers
Laravel check if email is real
PHP Laravel
2 votes224 views4 answers
Laravel htaccess
PHP Laravel
2 votes267 views2 answers
Laravel switch
PHP Laravel