如何在 eloquent (laravel 4) 中使用 substr 进行查询？

how to make query with substr in eloquent (laravel 4)?

提问by Carlos Su?ol

I have this query:

我有这个查询：

select substr(id,1,4) as id
from meteo.a2012
group by substr(id,1,4)

I just want to take first 4 numbers to my id row, but I'm trying to do in eloquent, how I do?

我只想把前 4 个数字带到我的 id 行，但我想用雄辩的方式做，我该怎么做？

Thanks.

谢谢。

回答by Jason Lewis

You need to use raw expressionsso you can use special functions like that.

您需要使用原始表达式，以便可以使用这样的特殊函数。

Model::select(DB::raw('substr(id, 1, 4) as id'))->groupBy(DB::raw('substr(id, 1, 4)'))->get();

Where Modelis your Eloquent model you want to run the query on.

Model你想运行查询的 Eloquent 模型在哪里。

回答by BCPNAYAK

$ids = Model::get(['id']);
foreach ($ids as $str)
{
    $str->id =substr($str->id,1,4);
}
return $ids;