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

9 votes297 views4 answers
Composer laravel ui
PHP Laravel
0 vote302 views1 answer
Laravel 404 not found not showing error
PHP Laravel
1 vote241 views2 answers
Laravel check if id in collection
PHP Laravel
28 votes304 views6 answers
Laravel make model with migration
PHP Laravel
3 votes280 views1 answer
Run laravel cron job on cpanel
PHP Laravel
0 vote272 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel
11 votes303 views2 answers
How login one user with id in laravel
PHP Laravel
0 vote306 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
1 vote287 views1 answer
Laravel redirect external url
PHP Laravel
0 vote306 views1 answer
Laravel collection shuffle
PHP Laravel