Zend_Db 按字段值排序

发布于 2024-08-20 06:36:16 字数 808 浏览 11 评论 0原文

我使用以下命令从模型输出选择菜单的内容：

$select = $this->select();
$select->order('name');
return $this->fetchAll($select);

但是，我想要做的是按特定值排序，然后按名称列排序。 SQL 如下所示：

SELECT * FROM `names` ORDER BY `name` = 'SomeValue' DESC,`name`

示例 SQL 代码：

CREATE TABLE IF NOT EXISTS `names` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `names` (`id`, `name`) VALUES
(1, 'rob'),
(2, 'dave'),
(3, 'andy'),
(4, 'paul'),
(5, 'jason'),
(6, 'john');

SELECT *
FROM `names`
ORDER BY `name` = 'john' DESC , `name`

6   john
3   andy
2   dave
5   jason
4   paul
1   rob

原文

I'm outputting the contents of a select menu from a model using this:

$select = $this->select();
$select->order('name');
return $this->fetchAll($select);

However, what i want to do is order by a specific value, and then by the name column. The SQL would look like this:

SELECT * FROM `names` ORDER BY `name` = 'SomeValue' DESC,`name`

SAMPLE SQL CODE:

CREATE TABLE IF NOT EXISTS `names` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `names` (`id`, `name`) VALUES
(1, 'rob'),
(2, 'dave'),
(3, 'andy'),
(4, 'paul'),
(5, 'jason'),
(6, 'john');

SELECT *
FROM `names`
ORDER BY `name` = 'john' DESC , `name`

RETURNS:

6   john
3   andy
2   dave
5   jason
4   paul
1   rob

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

葬心 2024-08-27 06:36:16

我相信这就是您正在寻找的：

$name = 'John';
$order = new Zend_Db_Expr($this->getAdapter()->quoteInto("name = ?", $name) ." DESC, `name`");
$select = $this->select();
$select->order($order);
return $this->fetchAll($select);

I believe this is what you are looking for:

$name = 'John';
$order = new Zend_Db_Expr($this->getAdapter()->quoteInto("name = ?", $name) ." DESC, `name`");
$select = $this->select();
$select->order($order);
return $this->fetchAll($select);

回复收藏 0 原文