how to find comma seperated column value from mysql

how to find comma seperated values in mysql

SELECT *
FROM  `vendor_master`
WHERE vendor_type =2
AND FIND_IN_SET( 1, work_type )
LIMIT 0 , 30

ArrayHelper::map(self::find()->where('vendor_type='. self::KARIGAR.' AND find_in_set('.$type.',work_type) ')->all(), 'id','name');

select * from shirts where ',' + colors + ',' like '%,1,%'