Zend Order by Cast with mysql

Question

I am using Zend Framework with a MySQL database.

Can zend select produce something like this ?

SELECT * FROM `abc` ORDER BY CAST( `something` AS SIGNED ), `other` ASC

at the moment i give raw sql query since don't know how to make zend use $select->order(..) and obtain that query...

I'm thinking maybe not all db support this so zend doesn't has it or why ?

JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

U can use Zend_Db_Expr class instance and pass it to order method