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

7 votes213 views2 answers
Laravel mail send to multiple recipients
PHP Laravel
1 vote167 views1 answer
Laravel redirect external url
PHP Laravel
1 vote169 views1 answer
Laravel foreach else
PHP Laravel
27 votes236 views3 answers
Laravel what is migrations
PHP Laravel
13 votes191 views4 answers
Laravel hash
PHP Laravel
1 vote177 views1 answer
Limiting requests to controllers in laravel
PHP Laravel
4 votes163 views2 answers
Laravel reduce
PHP Laravel
1 vote212 views4 answers
Laravel assign active based on route name
PHP Laravel
0 vote166 views1 answer
Laravel blade short if
PHP Laravel
22 votes179 views5 answers
Get logged user id laravel
PHP Laravel