mysql - 如何在 SQL 中订购包括单词顺序

Question

这是我的查询:

$select = $this->_conn->select();
    $select->from(array('usr' => $this->_prefix . 'user'));
    $select->join(array('rol' => 'role'), 'usr.role_id = rol.role_id',array());
    $select->join(array('law' => 'lawyer_details'), 'usr.user_id = law.user_id', array('lawyer_url'));
    $select->where("usr.user_status = ?","yes");
    $select->where("rol.role_key = ?","yes");
    $select->where("usr.user_section_show = ?","yes");
    $select->where("usr.managment_show = ?","yes");
    $select->limit(4);
    $select->order(array('usr.user_firstname ASC'));
    $rs = $select->query()->fetchAll();
    return new Obt_Model_RecordSet($rs, $this);

我想按 user_firstname 排序，但首先获取名称为“xxx”、“yyy”、“lll”的用户；

Answer 1

->order(new Zend_Db_Expr("FIELD(usr.user_firstname, 'xxx','yyy','lll')"));