我有一个表,其中包含名为MEASURATIONS的json列,如下所示:
{
"area" : "100",
"rooms" : "2",
.
.
.
}
我try 按区域排序,但没有返回正确的结果:
Home::where('status', 'active')->orderBy('measurements->area', 'asc')->get();
在那之后,我用了这个:
Home::query()
->where('status','active')
->orderByRaw('CAST(features->area AS unsigned)', 'asc')
->get();
但它返回错误:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'area AS unsigned) limit 14 offset 0' at line 1
如何才能准确地按json列排序?请编写代码.