How to query between alphabet range in sequelize?

Viewed 21

How can i query with sequelize between an alphabet range? Like: I want to get all registers that startsWith letters A to E. I've been trying to get it like this but it just gets the "E" items

      where: {
        id: user.id,
        name: {
          [Op.and]: {
            [Op.startsWith]: 'a',
            [Op.startsWith]: 'b',
            [Op.startsWith]: 'c',
            [Op.startsWith]: 'd',
            [Op.startsWith]: 'e',
          },
        },
      },
    });```
0 Answers
Related