How to sort string field as integer?

Question

Yii

Request for a selection of goods, sorted by capacity.

$products = Product()::find()->orderBy(['power' => SORT_ASC])->active()->all();

The catch is that in the database the power value is stored as a string and it is sorted in this
1000, 600, 750, 800, 900, 950
way
600, 750, 800, 900, 950, 1000.

Answer 1

Used the mysql CAST function

$sort = new Sort([
                        'attributes' => [
                            'power' => [
                                'asc' => [new Expression('CAST(' . AttributeValue::tableName() . '.value as SIGNED) ASC')],
                                'desc' => [new Expression('CAST(' . AttributeValue::tableName() . '.value as SIGNED) DESC')],
                                'default' => SORT_DESC,
                                'label' => 'Мощность',
                            ],
                        ],
                    ]);