sql - 我能做什么？ Sequelize isnull

Question

[表] USER_INFO

user_id  |  user_name
a123     |  facebook
b123     |  google
c123     |  NULL

[询问]

select isnull(user_name, user_id) as user_name from USER_INFO

[结果]

user_name
facebook
google
c123

[ Sequelize ] ???????

User.findAll({attributes: [
    user_id
    ,user_name
 ]
});

我想要相同的结果，查询 = Sequelize ..

Answer 1

尝试使用 where 运算符:

User.findAll({where:{
    user_name:{[Op.ne]:null}
},{attributes: [user_id,user_name]
}});