Magento 2 How to select fields in query

Question

I'm using below code

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$select = $connection->select()
        ->from(
        ['ce' => 'customer_entity']
);
$data = $connection->fetchAll($select);

It's working fine. It returns all customer fields. I would like to select only First Name, Last Name & Email.

Instead of select(), which function we need to use & how?

Sohel Rana · Accepted Answer · 2016-08-19 10:18:25Z

16

Try following way:

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$select = $connection->select()
    ->from(
        ['ce' => 'customer_entity'],
        ['firstname', 'lastname', 'email']
    );
$data = $connection->fetchAll($select);

answered Aug 19, 2016 at 10:18

Sohel Rana

36.2k3 gold badges74 silver badges94 bronze badges

1

How will we add where condition in this?

Amrit Pal Singh
– Amrit Pal Singh

2018-05-22 06:09:03 +00:00
Commented May 22, 2018 at 6:09
1

@AmritPalSingh - Taking reference from Sohel Rana's query after select statement(& before fetchAll) you can add where clause ie. $select->where('customer_id = ?', (int)$cust_id);

GunJan Mehta
– GunJan Mehta

2018-11-26 06:31:56 +00:00
Commented Nov 26, 2018 at 6:31
How can you make the select distinct?

Black
– Black

2022-12-02 15:14:24 +00:00
Commented Dec 2, 2022 at 15:14

Add a comment |

Kirti Nariya · Accepted Answer · 2020-02-03 05:17:45Z

Use below code for select particular field from database table.

File path: magento/app/code/Venodr/ModuleName/Model/CustomerData.php

<?php

namespace Venodr\ModuleName\Model;

use Magento\Framework\EntityManager\MetadataPool;
use Magento\Framework\EntityManager\Operation\ExtensionInterface;

class CustomerData
{
    protected $connection;

    public function __construct(
        \Magento\Framework\App\ResourceConnection $resource
    )
    {
        $this->connection = $resource->getConnection();
    }

    public function getQueryData()
    { 
        $query = $this->connection->fetchAll("SELECT firstname, lastname, email FROM customer_entity");
        return $query;
    }
}

Murtuza Zabuawala · Accepted Answer · 2023-10-19 18:48:15Z

0

$select = $adapter->select()
    ->from(
        ['c' => $tableName],
        ['*','total' => new \Zend_Db_Expr('c.qty + c.sale_qty')]
    );

edited Oct 19, 2023 at 18:48

Murtuza Zabuawala♦

14.8k10 gold badges47 silver badges76 bronze badges

answered Jun 21, 2023 at 8:46

Puneet

1096 bronze badges

1

Self blog promotion is not allowed

Murtuza Zabuawala
– Murtuza Zabuawala ♦

2023-10-19 18:47:50 +00:00
Commented Oct 19, 2023 at 18:47

Add a comment |

Stack Exchange Network

Magento 2 How to select fields in query

3 Answers 3

Your Answer

Hot Network Questions

Magento 2 How to select fields in query

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions