Zend DB Select : ORDER BY FIELD('id',some_array) - how?

Question

How would you write the following query in Zend framework?

SELECT * FROM table_name ORDER BY FIELD(field_name, 'Small','Medium','Large');

I just need the "Order by" part :)

Thanks!

Marcin · Accepted Answer · 2011-07-07 14:21:43Z

28

What about this:

      $db = Zend_Db_Table::getDefaultAdapter();

      $select = $db->select();

      $select->from('table_name')
              ->order(new Zend_Db_Expr("FIELD(field_name, 'Small','Medium','Large')"));


      var_dump($select->assemble());

Results in:

string 'SELECT `table_name`.* FROM `table_name` ORDER BY FIELD(field_name, 'Small','Medium','Large')' (length=92)

answered Jul 7, 2011 at 14:21

Marcin

241k16 gold badges315 silver badges368 bronze badges

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

Comments

Alex Pliutau · Accepted Answer · 2011-07-07 14:19:52Z

3

$select->order(new Zend_Db_Expr('FIELD(field_name, 'Small','Medium','Large')'));

answered Jul 7, 2011 at 14:19

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

Comments

Nicola Peluchetti · Accepted Answer · 2011-07-07 14:22:29Z

2

I think you should do:

$db = Zend_Db::factory( ...options... );
$select = $db->select()
 ->from(table_name)
 ->order(new Zend_Db_Expr("FIELD(field_name, 'Small','Medium','Large')")));

answered Jul 7, 2011 at 14:22

Nicola Peluchetti

77k32 gold badges150 silver badges197 bronze badges

Collectives™ on Stack Overflow

Zend DB Select : ORDER BY FIELD('id',some_array) - how?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related