Propel ORM:按字段排序 [英] Propel ORM: Order By FIELD

问题描述

我正在尝试使用 Propel 1.6 使用自定义order by"进行查询

I'm trying to do a query with a custom "order by" with Propel 1.6

select * from myObject ORDER BY FIELD(id, 3, 11, 7, 1)

这不起作用:

myObjectQuery::create()
    ->orderById($someIds)
    ->find()

我该怎么办?

推荐答案

$ids = array(3, 11, 7, 1);

$cids = implode(',', $ids);

myObjectQuery::create()
    ->addAscendingOrderByColumn("FIELD (tableName.id, {$cids})")
    ->find()

这篇关于Propel ORM:按字段排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！