How to search/ update an array of json object as the one below using Laravel?

Question

Sample Data

[{
    "name": "aml_kyc",
    "order": 4,
    "online": true,
    "enabled": true,
    "completed": false
}, {
    "name": "payment_video",
    "order": 6,
    "online": false,
    "enabled": true,
    "completed": false
}]

I tried $project->where('project_progress->name', 'aml_kyc')->first() but I get null

Laravel@latest [email protected]

Does this answer your question? Laravel Eloquent - Working with an array of JSON objects — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Feb 1, 2020 at 16:12

Ali Gajani · Accepted Answer · 2020-02-01 11:53:03Z

0

Because your condition query is wrong, and your json is nested by array.

Try to use JSON_CONTAINS

 $project->whereRaw('json_contains(project_progress, ?)', ['{"name":"aml_kyc"}'])->first()

edited Feb 1, 2020 at 11:53

Ali Gajani

15.1k12 gold badges64 silver badges106 bronze badges

answered Feb 1, 2020 at 11:39

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Ali Gajani Over a year ago

Still returning null.

Ali Gajani Over a year ago

The column name is project_progress. It is a JSON column.

Ali Gajani Over a year ago

Still the same. null

Ali Gajani Over a year ago

Now it returns the whole data, as in, the entire row in the database.

TsaiKoga Over a year ago

@AliGajani json_contains only return the row that project_progress contains {"name":"aml_kyc"}

|

Musa · Accepted Answer · 2020-02-01 11:42:02Z

-1

protected $casts = [
    'project_progress' => 'array',
];

answered Feb 1, 2020 at 11:42

Musa

1,3891 gold badge11 silver badges24 bronze badges

3 Comments

Ali Gajani Over a year ago

I want to be able to query and update some values though. PS: I am already doing casting.

Musa Over a year ago

can you try with whereJsonContains instead of where? what is your mySQL version?

Ali Gajani Over a year ago

My MySQL version is 5.7.27

Collectives™ on Stack Overflow

How to search/ update an array of json object as the one below using Laravel?

2 Answers 2

9 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related