Nested JSON-column where()

How can i query nested json objects in eloquent?

{
    "profile": {
        "age": 24
    }
}

->where('meta->profile.age', 24) does not work.

Best Answer

Level 51

Did you try

->where('meta->profile->age', 24)

Level 6

In Laravel 10

->where( 'meta.profile.age' ,  24 )

works for me

Please or to participate in this conversation.