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 vote226 views1 answer
Angular post phph
PHP
0 vote237 views1 answer
Laravel validation if another record is not deleted / not null
PHP
0 vote194 views1 answer
AUTO TRANSFER OF DATA FROM SYBASE TABLE TO PHPMYSQL TABLE
PHP
0 vote208 views1 answer
Php array all keys empty
PHP
1 vote217 views3 answers
Queue jobs in laravel
PHP
0 vote232 views1 answer
Call to a member function delete() on null laravel 8
PHP
0 vote241 views1 answer
Php options list view sidebar (240 x 500), list view results (600 x 180), listing page (450 x 200)
PHP
-2 votes229 views3 answers
Centos update php 7 to php 8
PHP
4 votes250 views2 answers
Datetime blade laravel
PHP Laravel
0 vote256 views1 answer
Get product price by id woocommerce snippet
PHP