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 ?

Answer 1

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

Answer 2

There is no such keyword in zend. We cannot make casting at the time of fetching the data but we can make casting after the fetching the data.

Answer 3

A ZF2 2019 answer:

$select->order(new Expression("CAST($orderColumn AS CHAR) $orderDirection"));

Since new Zend_Db_Expr do not work anymore ("renamed")