分析解答
假设您拥有eloquent model
,则可以利用DB Raw来实现这些自定义mysql
查询。
FgBarcode::
select(DB::raw('SUM(substr(fg_code, 22,14)) AS fg_code'))
->groupBy(DB::raw('substr(fg_code,2,3)'));
假设您拥有eloquent model
,则可以利用DB Raw来实现这些自定义mysql
查询。
FgBarcode::
select(DB::raw('SUM(substr(fg_code, 22,14)) AS fg_code'))
->groupBy(DB::raw('substr(fg_code,2,3)'));