推进 ORM : Order By FIELD

Question

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

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

这不起作用:

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

我能怎么做？

Answer 1

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

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

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