laravel where not code example
Example 1: 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
Example 2: laravel where like
$users = DB::table('users')
->where('name', 'like', 'T%')
->get();
Example 3: laravel not in query
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();