zend-frameworkzend-db

Zend Order by Cast with mysql

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 ?

Solution

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