entityMap|blocks|key|32a15|text|你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7oaa8|Table::select('name','surname')->where('id',+1)->get();|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

You can do it like this:

<pre><code>Table::select('name','surname')-&gt;where('id', 1)-&gt;get();
</code></pre>

entityMap|blocks|key|dlukc|text|Table::where('id',+1)->get(['name','surname']);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript^0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$C|D]]]]

<pre><code>Table::where('id', 1)-&gt;get(['name','surname']);
</code></pre>

entityMap|blocks|key|5p3s5|text|通过使用all()方法，我们可以从表中选择特定的列，如下所示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|a4dap|ModelName::all('column1',+'column2',+'column3');|code-block|syntax|javascript|2celf|注意|2dckl|：Laravel+5.4^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

By using all() method we can select particular columns from table like as shown below.

<pre><code>ModelName::all('column1', 'column2', 'column3');
</code></pre>

Note: Laravel 5.4

entityMap|blocks|key|37u8b|text|您还可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|70nh4|如下所示：|a8mc0|ModelName::find($id,+['name',+'surname']);|code-block|syntax|javascript|1j0qo|The+The+The|ebut5|变量可以是一个数组，以防需要检索模型的多个实例。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|P|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|Q|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|R|9|@]|A|@]|B|$]]]]

You can also use <code>find()</code> like this:

<pre><code>ModelName::find($id, ['name', 'surname']);
</code></pre>

The <code>$id</code> variable can be an array in case you need to retrieve multiple instances of the model.

entityMap|blocks|key|2oc7|text|您首先需要创建一个表示该表的模型，然后使用下面雄辩的方法仅获取2个字段的数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1cqh1|Model::where('id',+1)
+++++++++->pluck('name',+'surname')
+++++++++->all();|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

You first need to create a Model, that represent that Table and then use the below Eloquent way to fetch the data of only 2 fields.

<pre><code>Model::where('id', 1)
 -&gt;pluck('name', 'surname')
 -&gt;all();
</code></pre>

entityMap|blocks|key|nvg9|text|还有|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3uorv|它只会以数组的形式获取id。^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

Also <code>Model::all(['id'])-&gt;toArray()</code> it will only fetch id as array.

entityMap|blocks|key|f3slv|text|获取某一列的值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6jk3q|Table_Name::find($id)->column_name;|code-block|syntax|javascript|dceql|您可以将此方法与where子句一起使用：|9agou|Table_Name::where('id',$id)->first()->column_name;|1jquh|或者使用此方法绕过PhpStorm“在应用程序\模型中找不到的方法”：|dhv8m|Table_Name::query()->where('id','=',$id)->first()->column_name;|7uja4|在查询构建器中：|h0s3|DB::table('table_names')->find($id)->column_name;|eb2q|使用where+cluase：|4clld|DB::table('table_names')->where('id',$id)->first()->column_name;|eqbod|或者|2nun8|DB::table('table_names')->where('id',$id)->first('column_name');|439q7|最后一个方法的结果是数组^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|13|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|14|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|15|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|16|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|17|9|@]|A|@]|B|$]]|$2|N|4|O|6|E|8|18|9|@]|A|@]|B|$F|G]]|$2|P|4|Q|6|7|8|19|9|@]|A|@]|B|$]]|$2|R|4|S|6|E|8|1A|9|@]|A|@]|B|$F|G]]|$2|T|4|U|6|7|8|1B|9|@]|A|@]|B|$]]|$2|V|4|W|6|E|8|1C|9|@]|A|@]|B|$F|G]]|$2|X|4|Y|6|7|8|1D|9|@]|A|@]|B|$]]|$2|Z|4|10|6|E|8|1E|9|@]|A|@]|B|$F|G]]|$2|11|4|12|6|7|8|1F|9|@]|A|@]|B|$]]]]

Get value of one column:
<pre><code>Table_Name::find($id)-&gt;column_name;
</code></pre>
you can use this method with where clause:
<pre><code>Table_Name::where('id',$id)-&gt;first()-&gt;column_name;
</code></pre>
or use this method for bypass PhpStorm &quot;Method where not found in App\Models&quot;:
<pre><code>Table_Name::query()-&gt;where('id','=',$id)-&gt;first()-&gt;column_name;
</code></pre>
in query builder:
<pre><code>DB::table('table_names')-&gt;find($id)-&gt;column_name;
</code></pre>
with where cluase:
<pre><code>DB::table('table_names')-&gt;where('id',$id)-&gt;first()-&gt;column_name;
</code></pre>
or
<pre><code>DB::table('table_names')-&gt;where('id',$id)-&gt;first('column_name');
</code></pre>
last method result is array

entityMap|blocks|key|eivm5|text|您可以使用get()，也可以使用all()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c6u8v|ModelName::where('a',+1)->get(['column1','column2']);|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

You can use get() as well as all()

<pre><code>ModelName::where('a', 1)-&gt;get(['column1','column2']);
</code></pre>

entityMap|blocks|key|8krsl|text|来自laravel+5.3，仅使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5jkib|方法，您可以获取表的特定列：|dpq6l|YouModelName::get(['id',+'name']);|code-block|syntax|javascript|76k84|或者在laravel+5.4中，您还可以使用|9q96r|获取您选择的字段的方法：|e0dm6|YourModelName::all('id',+'name');|ct8o4|使用上述两种方法|fa99e|或者|b02to|您还可以使用|5qmps|但是两者的语法是不同的：|64hl9|Model::all()|3tvog|YourModelName::all('id',+'name')->where('id',1);|18sem|Model::get()|93te1|YourModelName::where('id',1)->get(['id',+'name']);^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|15|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|16|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|17|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|18|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|19|9|@]|A|@]|B|$]]|$2|N|4|O|6|G|8|1A|9|@]|A|@]|B|$H|I]]|$2|P|4|Q|6|7|8|1B|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|1C|9|@]|A|@]|B|$]]|$2|T|4|U|6|7|8|1D|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|1E|9|@]|A|@]|B|$]]|$2|X|4|Y|6|7|8|1F|9|@]|A|@]|B|$]]|$2|Z|4|10|6|G|8|1G|9|@]|A|@]|B|$H|I]]|$2|11|4|12|6|7|8|1H|9|@]|A|@]|B|$]]|$2|13|4|14|6|G|8|1I|9|@]|A|@]|B|$H|I]]]]

From laravel 5.3 only using <code>get()</code> method you can get specific columns of your table:

<pre><code>YouModelName::get(['id', 'name']);
</code></pre>

Or from laravel 5.4 you can also use <code>all()</code> method for getting the fields of your choice:

<pre><code>YourModelName::all('id', 'name');
</code></pre>

with both of above method <code>get()</code> or <code>all()</code> you can also use <code>where()</code> but syntax is different for both:

Model::all()

<pre><code>YourModelName::all('id', 'name')-&gt;where('id',1);
</code></pre>

Model::get()

<pre><code>YourModelName::where('id',1)-&gt;get(['id', 'name']);
</code></pre>

entityMap|blocks|key|20tc5|text|use+App\Table;
//+...
Table::where('id',1)->get('name','surname');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|a60hd|如果没有在哪里|unstyled|ffsa2|Table::all('name','surname');^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$C|D]]|$2|E|4|F|6|G|8|K|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|L|9|@]|A|@]|B|$C|D]]]]

<pre><code>use App\Table;
// ...
Table::where('id',1)-&gt;get('name','surname');
</code></pre>
if no where
<pre><code>Table::all('name','surname');
</code></pre>

entityMap|blocks|key|aug09|text|为了从表中获取特定列的结果，我们必须指定列名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2slqn|使用以下代码：|2m6e7|$result+=+DB::Table('table_name')->select('column1','column2')->where('id',1)->get();|code-block|syntax|javascript|eunnf|例如：|bbtkq|$result+=+DB::Table('Student')->select('subject','class')->where('id',1)->get();^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|P|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|Q|9|@]|A|@]|B|$]]|$2|L|4|M|6|G|8|R|9|@]|A|@]|B|$H|I]]]]

<h2>To get the result of specific column from table,we have to specify the column name.</h2>
Use following code : -
<pre><code> $result = DB::Table('table_name')-&gt;select('column1','column2')-&gt;where('id',1)-&gt;get(); 
</code></pre>
for example -
<pre><code>$result = DB::Table('Student')-&gt;select('subject','class')-&gt;where('id',1)-&gt;get(); 
</code></pre>

entityMap|blocks|key|7fdc|text|你也可以使用pluck。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ttad|Model::where('id',1)->pluck('column1',+'column2');|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

Also you can use pluck.

<pre><code>Model::where('id',1)-&gt;pluck('column1', 'column2');
</code></pre>

entityMap|blocks|key|e4gsb|text|如果您想从数据库中获取单个值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8gvs9|Model::where('id',+1)->value('name')|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

If you want to get a single value from Database
<pre><code> Model::where('id', 1)-&gt;value('name');
</code></pre>

entityMap|blocks|key|e4nc0|text|您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|aasvj|..。|f1rum|请记住，当仅选择某些字段时，如果您最终在请求中访问了其他字段(这可能很明显，只是希望包含该警告)，则必须进行另一次查询。包含id字段通常是一个好主意，这样laravel就知道如何写回您对模型实例所做的任何更新。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

You can use <code>Table::select ('name', 'surname')-&gt;where ('id', 1)-&gt;get ()</code>.

Keep in mind that when selecting for only certain fields, you will have to make another query if you end up accessing those other fields later in the request (that may be obvious, just wanted to include that caveat). Including the id field is usually a good idea so laravel knows how to write back any updates you do to the model instance.

entityMap|blocks|key|3qr8j|text|您还可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7tkrh|方法|57ov1|使用起来很好|dr5v4|如果未捕获到异常，则会自动将404+HTTP响应发送回用户。当使用这些方法而不给出500错误时，不需要编写显式检查来返回404响应。|8u42n|ModelName::findOrFail($id,+['firstName',+'lastName']);|code-block|syntax|javascript^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|O|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|P|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|Q|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|R|9|@]|A|@]|B|$L|M]]]]

you can also used <a href="https://laravel.com/docs/5.7/eloquent#retrieving-single-models" rel="nofollow noreferrer"><code>findOrFail()</code></a> method here it's good to used

<blockquote>
 if the exception is not caught, a 404 HTTP response is automatically sent back to the user. It is not necessary to write explicit checks to return 404 responses when using these method not give a 500 error..
</blockquote>

<pre><code>ModelName::findOrFail($id, ['firstName', 'lastName']);
</code></pre>

entityMap|blocks|key|3ehii|text|虽然最常见的方法是使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|625rr|，它会导致在模型类中呈现用访问器方法定义的所有属性。因此，如果您在模型中定义了属性：^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

While most common approach is to use <code>Model::select</code>, 
it can cause rendering out all attributes defined with accessor methods within model classes. So if you define attribute in your model: 

<pre><code>&lt;?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
 /**
 * Get the user's first name.
 *
 * @param string $value
 * @return string
 */
 public function getFirstNameAttribute($value)
 {
 return ucfirst($value);
 }
}
</code></pre>

And then use: 
<code>TableName::select('username')-&gt;where('id', 1)-&gt;get();</code>

It will output collection with both <code>first_name</code> and <code>username</code>, rather than only username. 

Better use <code>pluck()</code>, solo or optionally in combination with <code>select</code> - if you want specific columns. 

<code>TableName::select('username')-&gt;where('id', 1)-&gt;pluck('username');</code>

or 

<code>TableName::where('id', 1)-&gt;pluck('username');</code> //that would return collection consisting of only <code>username</code> values 

Also, optionally, use <code>-&gt;toArray()</code> to convert collection object into array.

entityMap|blocks|key|cr9km|text|如果想要获取单行和单列，则使用一行代码来获取特定列的值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7q8cd|方法，同时指定要检索它的列。|f85d2|以下是示例代码：|ape2i|ModelName::find($id_of_the_record,+['column_name'])->toArray()['column_name'];|code-block|syntax|javascript^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

If you want to get single row and from the that row single column, one line code to get the value of the specific column is to use <code>find()</code> method alongside specifying of the column that you want to retrieve it. 

Here is sample code:

<pre><code>ModelName::find($id_of_the_record, ['column_name'])-&gt;toArray()['column_name'];
</code></pre>

entityMap|blocks|key|i1ld|text|很像|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9jrj6|(及|7h4qi|等等)可以将您想要带回的字段作为参数；|b7qr0|将带回收藏品，但仅限于|32hte|和^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|L|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|M|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|N|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|O|9|@]|A|@]|B|$]]]]

<code>-&gt;get()</code> much like <code>-&gt;all()</code> (and <code>-&gt;first()</code> etc..) can take the fields you want to bring back as parameters;

<code>-&gt;get/all(['column1','column2'])</code>

Would bring back the collection but only with <code>column1</code> and <code>column2</code>

entityMap|blocks|key|62bs|text|您可以使用以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2c732|Table('table')->select('name','surname')->where('id',1)->get();|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

You can use the below query:

<pre><code>Table('table')-&gt;select('name','surname')-&gt;where('id',1)-&gt;get();
</code></pre>

entityMap|blocks|key|4tb8s|text|模型名称：：find($id，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7cmvq|‘'name'，'surname’|8vbm9|)；^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

ModelName::find($id, ['name', 'surname']);

lets say I have 7 columns in table, and I want to select only two of them, something like this

<pre><code>SELECT `name`,`surname` FROM `table` WHERE `id` = '1';
</code></pre>

In laravel eloquent model it may looks like this

<pre><code>Table::where('id', 1)-&gt;get();
</code></pre>

but I guess this expression will select ALL columns where id equals 1, and I want only two columns(name, surname). how to select only two columns?

How to select specific columns in laravel eloquent

数据库

 假设我在table中有7列，我只想选择其中的两列，如下所示 SELECT `name`,`surname` FROM `table` WHERE `id` = '1'; 在laravel雄辩模型中，它可能如下所示 Table::where('id', 1)->get(); 但是我猜这个表达式将选择id等于1的所有列，并且我只需要两列(name，surname)。如何只选择两列？

问如何在laravel eloquent中选择特定的列
EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在laravel eloquent中选择特定的列EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在laravel eloquent中选择特定的列
EN