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 vote311 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
0 vote300 views3 answers
Laravel tinker factory
PHP Laravel
32 votes335 views4 answers
Laravel seed fresh
PHP Laravel
4 votes261 views3 answers
Laravel description substring
PHP Laravel
12 votes271 views6 answers
Laravel validate date
PHP Laravel
0 vote302 views1 answer
Hasmany relationship with created at in laravel example
PHP Laravel
0 vote322 views1 answer
Laravel update single field
PHP Laravel
0 vote241 views1 answer
How to store multiple value in session in laravel
PHP Laravel
15 votes322 views3 answers
Pass data to blade laravel
PHP Laravel
12 votes296 views3 answers
How to log object laravel logger
PHP Laravel