mysql - 序列化和/或运算符

Question

我想在 Sequelize 中重现此查询:

SELECT name FROM table WHERE id = 5 AND (login = 1 OR register = 1)

我正在查看文档，这是我当前的代码:

Model.findOne({
        where: Sequelize.and({
            id: 5
            }, Sequelize.or({
                login: 1,
                register: 1
            })
        )
    })

但它不起作用。我对 Sequelize 还很陌生，希望有人能帮助我。

Answer 1

尝试这样:

Model.findOne({
    where: Sequelize.and({
        id: 5
        }, Sequelize.or(
               {login: 1},
               {register: 1}
           )
    )
})