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 vote278 views1 answer
Delay queue laravel
PHP Laravel
0 vote211 views1 answer
Laravel count by date
PHP Laravel
1 vote216 views1 answer
Laravel createmany example
PHP Laravel
1 vote239 views1 answer
Laravel end date greater than start date validation
PHP Laravel
0 vote217 views1 answer
Laravel 7 create-project
PHP Laravel
1 vote222 views1 answer
Maximum execution time of 60 seconds exceeded laravel 8
PHP Laravel
1 vote307 views1 answer
Mysqli_query insert in laravel
PHP Laravel
0 vote218 views1 answer
How to loop array in laravel
PHP Laravel
4 votes224 views2 answers
Laravel DB wherein
PHP Laravel
7 votes248 views3 answers
Laravel where has
PHP Laravel