Mysql Custom sorting using Zend

Question

i have this sql code

"SELECT * FROM t_one order by
                                    (
                                    case t_one.status
                                      when 'valid'   then 1
                                      when 'invalid' then 2
                                      when 'aborted'   then 3
                                      when 'cancel'  then 4
                                      else 9999
                                    end
                                    )";

How can i convert this to zend db model functions

Cristiano Santos · Accepted Answer · 2011-11-03 19:27:16Z

1

Maybe this could help:

http://zend-framework-community.634137.n4.nabble.com/SQL-Case-statement-in-Zend-Framework-td656393.html

answered Nov 3, 2011 at 19:27

Cristiano Santos

2,1372 gold badges39 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql Custom sorting using Zend

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related