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 vote250 views1 answer
Laravel not rollback even has error
PHP Laravel
1 vote146 views1 answer
Maximum execution time of 60 seconds exceeded laravel 8
PHP Laravel
18 votes165 views6 answers
Laravel form validation
PHP Laravel
0 vote143 views2 answers
Create model controller migration factory laravel in one command
PHP Laravel
3 votes150 views1 answer
Phone number validation, laravel
PHP Laravel
1 vote153 views1 answer
Laravel select all except some columns
PHP Laravel
4 votes164 views3 answers
Laravel 8 check if null or empty
PHP Laravel
0 vote168 views1 answer
Laravel collection partition
PHP Laravel
2 votes96 views2 answers
Laravel custom paginator links view
PHP Laravel
2 votes224 views3 answers
Laravel get query result as array
PHP Laravel