Magento 2: How to pass IN/OR Condition in Query

Question

I have below query

$customers = array(1,2);

$select = $connection->select()
->from(
        ['ce' => 'customer_entity'], ['entity_id', 'firstname', 'lastname', 'email'] // Select Only Required Fields
)
->where('ce.entity_id IN? ',$customers);
echo $select;
exit;

How to pass IN & OR condition?

Answer 1

You need to modify your where slightly. Replace:

->where('ce.entity_id IN? ',$customers);

With:

->where('ce.entity_id IN (?)', $customers);

Answer 2

FOR OR condition you can use :

->where(new Zend_Db_Expr("(CONDITION_1 OR (CONDITION_2 AND (CONDITION_3 OR CONDITION_4)))"));

OR you can use

->orWhere instead of ->where