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 vote301 views2 answers
Prestashop category as homepage
PHP
8 votes296 views1 answer
If any error in blade laravel
PHP
0 vote337 views1 answer
Laravel chain query builder
PHP Laravel
0 vote380 views2 answers
Recaptcha v3 laravel 8
PHP Laravel
0 vote363 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP Laravel
0 vote349 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel
0 vote284 views1 answer
Php get current url without filename
PHP
20 votes308 views6 answers
Print array php
PHP
0 vote312 views1 answer
Menu order for posts
PHP
0 vote282 views1 answer
Hashing passwords in yii 1
PHP