使用Laravel查询构建器仅选择第一个单元格中的第一个单元格

Question

Is there a method to select a first row cell in Laravel's query builder? Im looking for something like this:

$my_value = DB::table("my_table")
    ->select("value")
    ->where("key", "=", "my_key")
    ->getFirstRowCellValueOnly()

Yea, I could do it by selecting first row and then just selecting key "value" from returned array (->first()["value"]), but a default method would be more tidier ^ ^.

Answer 1

Yup, the method is called pluck().

$my_value = DB::table("my_table")
    ->select("value")
    ->where("key", "=", "my_key")
    ->pluck("value"); // same as in the select