How do I use the where clause in Sequelize?

How do I use the where clause in Sequelize?

In Sequelize, the where clause is used to filter results in your queries. You can specify conditions for your query.

Can you give me an example of a where clause?

Sure! For instance, if you want to find users with the name 'John', you can use: User.findAll({ where: { name: 'John' } });

What if I want to filter by multiple conditions?

You can combine conditions using operators. For example: User.findAll({ where: { age: { [Op.gt]: 18 }, name: 'John' } }); This finds users named John who are older than 18.

Are there any other operators I can use?

Yes, Sequelize supports various operators like Op.and, Op.or, Op.like, and more. You can check the Sequelize documentation for a full list.