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 vote384 views1 answer
Encode in laravel api
PHP Laravel
1 vote265 views1 answer
Failed to connect to github.com port 443: Connection timed out
PHP
1 vote259 views4 answers
Create laravel project specific version
PHP
0 vote286 views1 answer
WPML - Add a floating language switcher to the footer
PHP
0 vote273 views1 answer
Get record of last 24 hours in laravel
PHP
0 vote324 views1 answer
How to get all the records with same ID in laravel
PHP Laravel
0 vote260 views1 answer
Controller run
PHP
2 votes281 views3 answers
Write a php program to print hello world
PHP
0 vote302 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
0 vote255 views1 answer
Php post data empty
PHP