title: CakePHP model->find and IF condition in field
body: <p>I need to construct a cakePHP model query like this:</p>
  
  <pre><code>SELECT `Translate`.`var_name` , IF( prove_cn_sim =1, lang_cn_sim, lang_en )
  FROM 'translate` AS `Translate`
  </code></pre>
  
  <p>I've tried: </p>
  
  <pre><code>$this-&gt;find("list", array(
              'fields' =&gt; array("var_name","IF(prove_cn_sim = 1, lang_cn_sim, lang_en)"),
          ));
  </code></pre>
  
  <p>but I got something like this:</p>
  
  <pre><code>SELECT `Translate`.`var_name`, Translate.IF(prove_cn_sim = 1, lang_cn_sim, lang_en) FROM `translate` AS `Translate`
  </code></pre>
  
  <p>CakePHP add table prefix to IF. do you know any solutions?</p>