Zend Framework order by ascending null values last

Question

I my order by clause I want to do something like

select MyDate
from MyTable
order by case when MyDate is null then 1 else 0 end, MyDate

how can I write

order by case when MyDate is null then 1 else 0 end, MyDate

in Zend I already tried

->order('by case when MyDate is null then 1 else 0 end', 'MyDate')

suggestions?

score 2 · Answer 1 · edited May 23 '17 at 11:56

2

Following what I found on this article, MySQL Orderby a number, Nulls last, this maybe could work for you:

->order(new Zend_Db_Expr("-MyDate DESC"));

edited May 23 '17 at 11:56

Community

answered Mar 06 '15 at 13:25

Ernesto Allely

score 1 · Answer 2 · answered Jan 29 '14 at 15:21

Would be nice to provide us with error message or echo $select so we could see where problem is.

Try this:

->order(new Zend_Db_Expr('case when MyDate is null then 1 else 0 end, MyDate'));

Passing Zend_Db_Expr object always puts it in query 'as it is' with no modification.

2 Answers2