[FIXED] How to retrieve Json data type data in SQL using a where condition in LARAVEL

Issue

Question : How to retrieve Json data type data in SQL using a where condition in LARAVEL?

I want to display all the order that contains order->Product->user->id === 1

{
"currentUserID": 1,
"currentUserName": "Mohamed Naalir",
"order": [
    {
        "id": 26,
        "Product": [
            {
                "id": 4,
                "name": "Araliya Rice",
                "desription": "Araliya Rice",
                "salePrice": 500,
                "category": "Rice",
                "user": {
                    "id": 1,
                    "name": "Mohamed Naalir",
                }
            }
        ],
    },
    {
        "id": 27,
        "Product": [
            {
                "id": 2,
                "name": "white sugar",
                "desription": "aaa",
                "salePrice": 100,
                "category": "Sugar",
                "user": {
                    "id": 5,
                    "name": "Mohamed Sharaf",
                }
            }
        ],
    }
]

}

Solution

json where clauses

 $orders = DB::table('orders')
            ->whereJsonContains('Product', [['user' => ['id' => 1]]])
            ->get();

Answered By - Mohamed Raza

Answer Checked By - Robin (PHPFixing Admin)