title: Function mysql in cakephp
body: <p>I'm trind to do a query like this:</p>
  
  <pre><code>$this-&gt;set('title', 'Lista de Posts');
  $Posts = $this-&gt;Post-&gt;query("SELECT id,Titulo,Data,Hora,RIGHT(Conteudo,200) AS Conteudo,Usuario FROM posts;");
  $this-&gt;set('posts', $Posts);
  $this-&gt;layout = 'home';
  </code></pre>
  
  <p>But in the view i receive this message:</p>
  
  <p>Notice (8): Undefined index: Post [APP/View/Posts/home.ctp, line 4]</p>
  
  <p>But with $Posts = $this->Post->find('all') it works.</p>
  
  <p>Please can anyone help me to use RIGHT(Conteudo,200) in cake php?</p>
  
  <p>Thanks</p>