mysql - Sequelize And / Or Operators

Question

I want to reproduce this query in Sequelize:

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

I was looking on docs and here's my currently code:

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

But it's not working. I'm pretty new in Sequelize, hope anyone can help me.

标签： mysqlnode.jssequelize.js

Answer 1

试试这样：

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