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 vote252 views1 answer
Tinyinteger laravel +size
PHP Laravel
0 vote266 views1 answer
Laravel log permission denied mac
PHP Laravel
0 vote230 views1 answer
Laravel repository error
PHP Laravel
2 votes178 views1 answer
Laravel create txt file
PHP Laravel
5 votes188 views1 answer
Bootstrap blade pagination
PHP Laravel
0 vote215 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP Laravel
3 votes222 views2 answers
Insert into laravel 8
PHP Laravel
5 votes219 views3 answers
Laravel display error message
PHP Laravel
0 vote365 views1 answer
Parameter to laravel seeder
PHP Laravel
0 vote224 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel