title: ZEND FRAMEWORK => CONCAT to Select
body: <p>I have this query:</p>
  
  <pre><code>-&gt;join(array('p'=&gt;'persona'),'u.persona_id=p.id',array('nomp'=&gt; new Zend_Db_Expr("CONCAT(p.nombre, ' ', p.apellidos)")))
  </code></pre>
  
  <p>I concatenated (<code>p.nombre</code> y <code>p.apellidos</code>) and give them that has the name of "nomp"</p>
  
  <p>When I do the "Where" and give it a "LIKE" I look for the column "nomp" zend tells me that column does not exist.</p>
  
  <p>You know any other way to concatenate.</p>