How to apply filter on magento 2 collection like below query?

Question

THis is my core Mysql query

select * from table_name where CONCAT(',', subscriptions, ',') like '%,4793,%'

and i want to apply below filter on magento 2 collection. where CONCAT(',', subscriptions, ',') like '%,4793,%'

Answer 1

Use Zend_Db_Expr

Example:

$collection->getSelect()->where(new \Zend_Db_Expr("CONCAT(',', subscriptions, ',') LIKE (?)"), '%,4793,%');