'Querying inside json column in laravel elequent
i have a model called orders which have an info json column .
in that json i have a property called id . now i want to retrieve all orders with the id of 6 for example . so here is how i have done like below :
$order = \DB::table('orders')
->where('info.id',$value)
// ->where('info->id',$value)
// ->whereRaw('JSON_EXTRACT(`info` , "$.id") = '.$value)
->first();
the third whereRaw is working but i think it has a bug because in my validation thirds or 4th one returns this error which is so strange :
Column not found: 1054 Unknown column '6112 ' in 'where clause' (SQL: select * from `orders` where JSON_EXTRACT(`info` , "$.id") = 6112 limit 1)
it some how mistakes the column value as the column name which is so strange because its working on first ones when i dd i get the values from query but it breakes on like 4th one .
now i wanted to know if there is any easier solution to use where on json fields or what is the problem with that whereRaw
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
