我有一个单一的输入搜索名称前端,但我的数据库将他们分为两个领域。我想做的是单独运行concat和like语句,包括:
SELECT * FROM users WHERE (CONCAT(first_name, ' ', last_name)) LIKE '%John Do%' AND permission_id = 1 AND user_status_id = 1;
现在我要说的是:
let name = req.params.name;
let userId = req.user;
debugger;
db.user.findAll({
where: {
attributes: [db.sequelize.fn('concat', db.Sequelize.col('first_name'), ' ', db.Sequelize.col('last_name'), 'full_name'), {
like: `%${name}%`
}],
},
include : [
db.client
]
})
但我想不出应该在哪里包括类似的或concat
暂无答案!
目前还没有任何答案,快来回答吧!