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 vote177 views1 answer
Condition for both of one should be true laravel eloquent
PHP Laravel
1 vote173 views2 answers
Laravel cronjob
PHP Laravel
2 votes175 views1 answer
Laravel scheduler every 2 hours
PHP Laravel
0 vote180 views1 answer
Laravel get data from model to controller
PHP Laravel
0 vote173 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP Laravel
1 vote194 views1 answer
Laravel task scheduling command
PHP Laravel
2 votes166 views1 answer
Return back in blade laravel
PHP Laravel
7 votes183 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
9 votes191 views2 answers
Laravel query count raw
PHP Laravel
8 votes142 views1 answer
Laravel get variable from url
PHP Laravel