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

42 votes217 views5 answers
Create controller laravel with model
PHP Laravel
1 vote198 views1 answer
Group_concat laravel
PHP Laravel
3 votes175 views2 answers
How to remove duplicates in a sorted array
PHP
1 vote194 views2 answers
Laravel model is dirty
PHP
-1 vote170 views1 answer
ERROR: Module mpm_event is enabled - cannot proceed due to conflicts. It needs to be disabled first! Considering conflict mpm_worker for mpm_prefork: ERROR: Could not enable dependency mpm_prefork for php7.2, aborting
PHP
1 vote186 views1 answer
Php begin tag
PHP
15 votes207 views6 answers
Laravel db transaction
PHP Laravel
11 votes191 views4 answers
Randstring php
PHP
2 votes204 views4 answers
Laravel run schedule locally
PHP Laravel
18 votes174 views3 answers
Php try json decode
PHP