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 vote165 views1 answer
Laravel create new file if not exists
PHP Laravel
8 votes150 views4 answers
Laravel set date format
PHP Laravel
0 vote149 views1 answer
Laravel range query
PHP Laravel
2 votes157 views2 answers
Laravel insert timestamp now
PHP Laravel
0 vote143 views1 answer
Unique string faker laravel
PHP Laravel
0 vote153 views3 answers
Laravel 7 pagination with search filter
PHP Laravel
1 vote167 views1 answer
Laravel @canany
PHP Laravel
1 vote145 views2 answers
Laravel return response view
PHP Laravel
1 vote183 views1 answer
Get year in laravel 8
PHP Laravel
1 vote156 views1 answer
Laravel emial unique igration error
PHP Laravel