Laravel JSON query

Laravel query json

$users = DB::table('users')
                ->whereJsonContains('options->languages', ['en', 'de'])
                ->get();

Source: laravel.com

Laravel JSON Where Query

$users = DB::table('users')
                ->where('options->language', 'en')
                ->get();

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();

Source: laravel.com

Laravel JSON query

$users = DB::table('users')
                ->where('preferences->dining->meal', 'salad')
                ->get();

Source: laravel.com

Similar codes

0 vote374 views2 answers
Str lower laravel
PHP Laravel
15 votes345 views6 answers
Transaction laravel
PHP Laravel
6 votes345 views2 answers
Laravel findorfail
PHP Laravel
13 votes344 views4 answers
Laravel login by id
PHP Laravel
9 votes340 views4 answers
Add another field in existing migration laravel
PHP Laravel
5 votes372 views3 answers
Enum table in laravel
PHP Laravel
0 vote369 views2 answers
Iframe site bi link laravel
PHP Laravel
0 vote397 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
0 vote323 views3 answers
Laravel package console command
PHP Laravel
3 votes308 views3 answers
Laravel passport create access token
PHP Laravel