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

1 vote203 views1 answer
Operador in laravel
PHP Laravel
0 vote211 views1 answer
Generate slug on create laravel
PHP Laravel
2 votes191 views1 answer
Laravel commands to refresh env file
PHP Laravel
0 vote187 views2 answers
Option selected in laravel blade
PHP Laravel
0 vote264 views1 answer
Get data in array formate in Laravel
PHP Laravel
1 vote231 views1 answer
Unless blade laravel
PHP Laravel
14 votes202 views3 answers
Log facade laravel
PHP Laravel
8 votes161 views1 answer
Laravel get variable from url
PHP Laravel
0 vote192 views1 answer
Model hasmany laravel
PHP Laravel
1 vote201 views1 answer
Laravel hasone users relations
PHP Laravel