/PHP/Laravel where json array column

Laravel where json array column

Laravel where json array column

->whereJsonContains('user_id', 3)

0

Source: laracasts.com

Laravel where json array column

whereRaw("JSON_CONTAINS(user_id, '[3]' )")->get();

0

Source: laracasts.com

Laravel where json array column

$listOfUser = [1, 3, 5, 6, 8, 9];

$users = DB::table('users')
                    ->whereIn('user_id', $listOfUser)
                    ->get();

0

Source: laracasts.com

Similar codes

3 votes233 views2 answers
How to export database from phpmyadmin
PHP
42 votes284 views6 answers
Laravel 8 foreign key
PHP
9 votes279 views6 answers
Laravel 8 date format
PHP
1 vote259 views1 answer
How to setup cronjob on cakephp on share hosting
PHP
1 vote290 views1 answer
Convert space to 20 php
PHP
5 votes254 views1 answer
Debug wordpress errors
PHP
14 votes314 views6 answers
Laravel Password Validation
PHP Laravel
1 vote296 views1 answer
Behamin brequest installation on laravel
PHP Laravel
0 vote290 views1 answer
Get curret timedate php
PHP
25 votes280 views6 answers
Laravel carbon date format
PHP

Share