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

1 vote169 views1 answer
Laravel model find one
PHP
3 votes190 views2 answers
Laravel drop column softdeletes
PHP
0 vote189 views2 answers
Return html in yajra datatables
PHP
103 votes220 views6 answers
Array_push php
PHP
17 votes190 views6 answers
String to array in php
PHP
0 vote192 views1 answer
The plugin generated 14 characters of unexpected output during activation. if you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin
PHP
0 vote204 views1 answer
Next previous post link
PHP
1 vote192 views2 answers
Laravel init
PHP
0 vote214 views3 answers
Get category name by id wordpress
PHP Wordpress
4 votes194 views5 answers
Laravel array_pluck
PHP Laravel