Q:

How to convert SQL query to CakePHP query

I have following query where interest is field name.  interest contains like football,vollyball etc. 
SELECT * FROM `drop_down_multiples` where find_in_set('football',`interest`);

I stuck to convert above query in CakePHP.  How I can convert ? 
Thanks. 

A:

Some thing like this :-
cakephp haven't any function for this,you have to do some tricks that how cakephp built the 
sql queries from their syntax. 
$this->DropDownMultiples->find('all',array(
  'conditions'=>array('FIND_IN_SET("'.$search_field. '",DropDownMultiple.interest)‌​')
  ));

