how to use "find_in_set" in cakephp find method

Question

I have a table in which comma seprated id of another table i want to use the following query in cakephp in proper form with find function

"select * from special_offers where find_in_set('".$storeId."', stores) and user_id = '". $userId ."'";

Answer 1

Use like this

$data = $this->SpecialOffer->find('all',array('conditions' => array('SpecialOffer.user_id' => $userId ,'FIND_IN_SET(\''. $storeId .'\',SpecialOffer.stores1)')));

Hope this may help you