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 vote328 views1 answer
Running laravel project in mobile phone
PHP Laravel
1 vote359 views1 answer
How to pass data to controller in laravel
PHP Laravel
0 vote343 views1 answer
Raw query in laravel with parameters
PHP Laravel
0 vote366 views1 answer
Check laravel first null
PHP Laravel
33 votes370 views6 answers
Laravel carbon
PHP Laravel
28 votes333 views6 answers
Laravel drop foreign key
PHP Laravel
-1 vote375 views1 answer
Laravel migration table bigint
PHP Laravel
0 vote339 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
0 vote291 views2 answers
Laravel blade empty
PHP Laravel
13 votes337 views5 answers
Laravel validation custom message example
PHP Laravel