Magento Magento 2 query to get all active payment methods March 15, 2018 Pramod T P Leave a comment Following query will help you to get the active payment methods in magento 2. select * from core_config_data where path like '%payment%' and path like '%active%' and value=1;