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 vote151 views1 answer
Php compress csv file
PHP
0 vote187 views1 answer
Phpexcel rangetoarray date format
PHP
0 vote183 views1 answer
Comment installer laravel avec docker
PHP Laravel
0 vote184 views2 answers
Script inside php
PHP
15 votes183 views6 answers
Laravel db transaction
PHP
0 vote134 views1 answer
Php value to javascript variable laravel blade
PHP
0 vote132 views1 answer
Laravel imap - Set message flags
PHP
1 vote134 views3 answers
Check table exists in db laravel
PHP
0 vote134 views1 answer
Return false inside loop of function php
PHP
0 vote135 views1 answer
Laravel maintenance mode custom class
PHP