sql - sequelize 原始查询列不存在

Question

我尝试使用原始查询，但我收到错误。
为什么它认为 test 是一个列名？

列“测试”不存在

module.exports = {

  getUser(req, res){
    var sql = 'SELECT * FROM Users As Users WHERE Users.username = "test"'
    //Get the username of the user
    //Search the Users_matches databse for their username and join it with the
    db.sequelize.query(sql, { type: sequelize.QueryTypes.SELECT})
    .then(result => {
      return res.status(201).send({
        result
      });
    })
}

Answer 1

您可以转义值“test”。这有效

const User = sequelize.define('User', {
  username: Sequelize.STRING,
});

sequelize.sync({ force: true })
  .then(() => {
    var sql = 'SELECT * FROM "Users" as "Users" WHERE username = \'test\'';
    sequelize.query(sql, { type: sequelize.QueryTypes.SELECT })
      .then(result => {
        console.log(result);
      });
  });