mysql - cake php或mysql查询中根据 'IN'子句获取查询结果顺序

Question

在 cake php 中，我们如何根据查询中的“IN”子句获取查询结果的顺序

$array = array(8,6); // order in 'In' clause
$condition = array('Video.id' => $array);
$videos = $this->Video->find('all', array('conditions' => $conditions));

//The query will be like below
SELECT * FROM `videos` AS `Video` WHERE `Video`.`id` IN (8,6);

目前它会给出结果

Array
(
    [0] => Array
    (
        [Video] => Array
        (
            [id] => 6
        )

    )

    [1] => Array
    (
        [Video] => Array
        (
            [id] => 8
        )

    )

)

我需要这样的

Array
(
    [0] => Array
    (
        [Video] => Array
        (
            [id] => 8
        )

    )

    [1] => Array
    (
        [Video] => Array
        (
            [id] => 6
        )

    )

)

order Desc 或 asc 不会按顺序检索实际结果。如何使用 cake php 恢复它？

我正在使用 cake php，是否可以在 mysql 中完成？

Answer 1

ORDER 是 CakePHP 中的一个选项吗？

$this->Video->find('all', array('conditions' => $conditions, 'order' => array('Video.id DESC')));

回应评论:

$this->Video->find('all', array('conditions' => $conditions, 'order' => array('FIELD(Video.id, 7, 4, 9)')));