title: Cake php Search with multiple like condition
body: <pre><code>SELECT * 
  FROM product_details
  WHERE material_id LIKE  '%4'
  OR material_id LIKE  '%5'
  ORDER BY  `product_details`.`material_id` ASC 
  LIMIT 0 , 30
  </code></pre>
  
  <p>My Condition is like </p>
  
  <pre><code>$conditions[] = array(
      'OR' =&gt; array(
          'LOWER(`Product`.`product_name`) LIKE' =&gt; '%'.$search_query.'%',
          'LOWER(`ProductDetail`.`designer_id`) LIKE' =&gt; '%'.$get_designer_id.'%',
          'LOWER(`Product`.`category_id`) LIKE' =&gt; '%'.$get_category_id.'%',
          'LOWER(`ProductDetail`.`color_id`) LIKE' =&gt; $color_id,
          'LOWER(`ProductDetail`.`material_id`) LIKE' =&gt; '%'.$meterial_id.'%',
          'LOWER(`ProductDetail`.`product_code`) LIKE' =&gt; '%'.$search_query.'%',
          //'LOWER(`ProductDetail`.`gbp_price`) LIKE' =&gt; '%'.$search_query.'%',
         // 'LOWER(`ProductDetail`.`euro_price`) LIKE' =&gt; '%'.$search_query.'%',
          'LOWER(`ProductDetail`.`description`) LIKE' =&gt; '%'.$search_query.'%',   
      ),             
  );  
  </code></pre>
  
  <p>How To write this query in cake php</p>