Home / Questions / 502390
Accepted
Darinel Cigarroa
Asked: 2022-05-10 12:05:48 +0800 CST 2022-05-10 12:05:48 +0800 CST

Check with Eloquent to fetch only a certain field from all my records?

  • 772

Hello, what I am trying to do is bring all the records of my table but the field that I want to bring is only "table_name", I have made the following query using Eloquent, my question would really be what is the best way since I have read that some queries can be more optimized than others. And how can I know this? This is my query with Eloquent:

CatAdministrator::all()->pluck('table_name');
laravel

1 Answers

  1. Best Answer

    If the method all()does not specify the columns from which you want to retrieve the values, then it will do a general selection.

    Then you can write it like this:

    CatAdministrador::all(['table_name']);

    The output produced would be something like this:

    [
    {},
    {},
    .....
]

    However, if you use a pluck()in this way:

    CatAdministrator::pluck('table_name');

    The output produced would be:

    [valor1, valor2, ......, valorN]

    Final comments:

    • If you leave the current query then you must first obtain a collection with all the information and then generate an array with the values ​​that you filter through pluck, which does not seem practical.
    • I recommend reviewing both methods since they help you obtain the necessary information ( making the corresponding editions ), the question is in which format is more functional for you
    • 0