1、find_in_set在magento2中的使用方法

方法一：

$sku = $sku->getCollection()->addFieldToFilter('sku',$product_sku)
            ->addFieldToFilter('is_active',1)
            ->addFieldToFilter('stores',array(
                array('finset'=> array(ObjectManager::getInstance()->get(StoreManagerInterface::class)->getStore()->getId()))
            ))->getFirstItem();

方法二：

$collection->addAttributeToFilter(
    array(
        array('attribute'=> 'attributecode','finset' => array('237')),
        array('attribute'=> 'attributecode','finset' => array('237')),
        array('attribute'=> 'attributecode','finset' => array('237')),
    )
);