How to use the Op function from sequelize

sequelize.Op is an object in the Sequelize ORM library that contains a set of operators that can be used in database queries.

How does sequelize.Op work?

sequelize.Op is an object in the Sequelize ORM library that contains a set of operators that can be used in database queries.

When defining a query with Sequelize, the Op object can be used to specify the operator to use for a particular comparison. For example, to find all users with a name containing the string 'John', we can use the Op.like operator like this:

javascriptCopy code
const { Op } = require('sequelize');
const users = await User.findAll({
  where: {
    name: {
      [Op.like]: '%John%'
    }
  }
});

In this example, we use Op.like to specify a case-insensitive search for the string 'John' within the name column of the User model. The resulting query would be translated to SQL like this:

sqlCopy code
SELECT * FROM users WHERE name LIKE '%John%';

The sequelize.Op object also contains other comparison operators, such as Op.gt (greater than), Op.lt (less than), Op.between (between two values), Op.in (in an array of values), and many more.

For example, we could use Op.between to find all users with a birthdate between two dates:

javascriptCopy code
const users = await User.findAll({
  where: {
    birthdate: {
      [Op.between]: ['1990-01-01', '2000-01-01']
    }
  }
});

In this example, we use Op.between to specify a range query for the birthdate column of the User model, where the value must be between '1990-01-01' and '2000-01-01'. The resulting query would be translated to SQL like this:

sqlCopy code
SELECT * FROM users WHERE birthdate BETWEEN '1990-01-01' AND '2000-01-01';

By using the sequelize.Op object in this way, we can create flexible and powerful database queries with Sequelize.

Ai Example

1
2
3
4
5
6
7
8
const { Op } = require("sequelize");
const users = await User.findAll({
  where: {
    name: {
      [Op.like]: "%John%",
    },
  },
});

In this example, we use sequelize.Op to specify the Op.like operator for a case-insensitive search for the string 'John' within the name column of the User model. We pass the where option to the findAll method, which specifies the search criteria for the query. Within the where option, we use an object with a name property that contains another object with the Op.like operator and the search string '%John%'. When the findAll method is called, Sequelize will construct a SQL query that includes the LIKE operator for the specified column and search string. We could also use other operators in a similar way, such as Op.gt, Op.lt, Op.between, and many more. For example, we could use Op.between to find all users with a birthdate between two dates: javascript Copy code