Yii2: updateAll with several conditions

Question

How to update all records according to my condition? (my code is not working)

$condition[] = ['>', 'position', $old_position];
$condition[] = ['<=', 'position', $new_position];
$condition[] = ['in', 'id', $ids];

Video::updateAll([
    'position' => new \yii\db\Expression('@a := @a + 1'),
], $condition);

Answer 1

You forgot the operator, just try:

$condition = ['and',
    ['>', 'position', $old_position],
    ['<=', 'position', $new_position],
    ['in', 'id', $ids],
];

More details: http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail