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 vote304 views1 answer
Php git pull webhook
PHP
0 vote349 views5 answers
Laravel Scheduler
PHP
0 vote427 views1 answer
Delete previous uploaded image when update laravel
PHP Laravel
0 vote381 views2 answers
Laravel migration change column order
PHP Laravel
10 votes333 views4 answers
Laravel table data types
PHP Laravel
0 vote339 views1 answer
Check if any field update laravel
PHP Laravel
0 vote355 views1 answer
Laravel resource command
PHP
0 vote336 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP
2 votes299 views1 answer
If condition inside echo in php
PHP
10 votes332 views6 answers
Laravel Pagination
PHP