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

6 votes208 views3 answers
Set route name laravel
PHP Laravel
0 vote216 views2 answers
Show query in laravel
PHP Laravel
0 vote213 views1 answer
How to validate email or phone number single parameter request in laravel
PHP Laravel
0 vote205 views1 answer
Extension gd missing laravel composer update
PHP Laravel
3 votes223 views1 answer
Laravel validation greater than or equal to
PHP Laravel
1 vote185 views1 answer
Check which database connect laravel
PHP Laravel
1 vote169 views1 answer
Trim laravel
PHP Laravel
7 votes217 views5 answers
Laravel remove public from url
PHP Laravel
1 vote215 views1 answer
Model json laravel accessor to convert to array
PHP Laravel
0 vote205 views1 answer
Raw query in laravel with parameters
PHP Laravel