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 vote271 views1 answer
Laravel connection timed out
PHP Laravel
0 vote325 views1 answer
Laravel npm run dev mix error FIX
PHP Laravel
0 vote276 views1 answer
Laravel auth trying to get property 'instid' of non-object
PHP Laravel
1 vote316 views1 answer
Laravel refresh server
PHP Laravel
0 vote327 views1 answer
Laravel favicon
PHP Laravel
0 vote322 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP Laravel
0 vote349 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
2 votes300 views1 answer
Reset password multipple database laravel
PHP Laravel
0 vote315 views1 answer
Generate slug on create laravel
PHP Laravel
0 vote294 views1 answer
Migration not found laravel
PHP Laravel