new Expression 使用

SELECT 0 AS type FROM szy_user u WHERE user_id=2

  1. <?php
  3. // SELECT 0 AS `type` FROM `szy_user` `u` WHERE `user_id`=2
  4. echo User::find()->select([
  5.   'type' => new Expression('0')
  6. ])
  7.   ->alias('u')
  8.   ->where([
  9.     'user_id' => 2
  10.   ])
  11.   ->createCommand()
  12.   ->getRawSql();
  14. // SELECT 0 AS `type` FROM `szy_user` `u` WHERE `user_id`=2
  15. echo (new \yii\db\Query())->select([
  16.   'type' => new Expression('0')
  17. ])
  18.   ->from([
  19.     'u' => User::tableName()
  20.   ])
  21.   ->where([
  22.     'user_id' => 2
  23.   ])
  24.   ->createCommand()
  25.   ->getRawSql();