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 vote408 views1 answer
Php get file location
PHP
5 votes330 views1 answer
Why we use .htaccess file in php
PHP
28 votes335 views6 answers
Laravel change column type
PHP Laravel
0 vote344 views2 answers
Laravel create event listener
PHP Laravel
0 vote322 views6 answers
Sanctum laravel
PHP Laravel
0 vote368 views1 answer
How to index column in laravel
PHP Laravel
0 vote329 views1 answer
Change sender name laravel
PHP
6 votes307 views3 answers
Ubuntu php uninstall
PHP
0 vote294 views1 answer
Woocommerce change "Billing Details" text
PHP
2 votes281 views1 answer
Your composer dependencies require a php version ">= 7.3.0"
PHP