title: Zend Order by Cast with mysql
body: <p>I am using Zend Framework with a MySQL database.</p>
  
  <p>Can zend select produce something like this ?</p>
  
  <pre><code>SELECT * FROM `abc` ORDER BY CAST( `something` AS SIGNED ), `other` ASC
  </code></pre>
  
  <p>at the moment i give raw sql query since don't know how to make zend use <code>$select-&gt;order(..)</code> and obtain that query...</p>
  
  <p>I'm thinking maybe not all db support this so zend doesn't has it or why ?</p>