mysql - Zend DB Select : ORDER BY FIELD ('id' , some_array) - 怎么样？

Question

您将如何在 Zend 框架中编写以下查询？

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

我只需要“Order by”部分 :)

谢谢!

Answer 1

这个呢:

      $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());

结果:

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