Laravel whereRaw

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();

Laravel wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

Laravel whereRaw

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Laravel whereRaw

use Illuminate\Support\Facades\DB;

$first = DB::table('users')
            ->whereNull('first_name');

$users = DB::table('users')
            ->whereNull('last_name')
            ->union($first)
            ->get();

Source: laravel.com

Similar codes

0 vote147 views1 answer
How to display the responce of curl in php
PHP
0 vote192 views3 answers
Laravel package console command
PHP Laravel
0 vote176 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel
40 votes142 views6 answers
Laravel drop column
PHP
11 votes179 views1 answer
Install php 8.1 fpm and all modules on ubuntu
PHP
15 votes163 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP
0 vote390 views1 answer
Get node id in twig drupal
PHP
0 vote141 views1 answer
Failed to authenticate on SMTP server with username
PHP
0 vote127 views1 answer
Php run python script with arguments json
PHP
0 vote150 views1 answer
@method overide form laravel
PHP