我正在try 设置一些简单的SQL脚本来帮助进行一些短期的数据库管理.
我遇到的问题就是LIKE条款.
SET @email = 'test@test.com';
SELECT email from `user` WHERE email LIKE '%@email%';
所以我想让它根据变量中设置的邮箱查找结果.如果我手动将邮箱输入LIKE子句,查询就会生效.
如何让LIKE子句与用户变量一起工作?
更新:
SET @email = 'test@test.com';
SELECT project.projectno, project.projectname, login.username,
CONCAT(login.firstname, ' ', login.lastname), projectuser.title
FROM projectuser
INNER JOIN login ON projectuser.uid = login.uid
LEFT JOIN project ON projectuser.pid = project.pid
WHERE login.username LIKE CONCAT ('%', @email, '%')
给出错误"函数mydb.CONCAT不存在"
查询在没有CONCAT()的情况下工作:
SET @email = 'test@test.com';
SELECT project.projectno, project.projectname, login.username,
CONCAT(login.firstname, ' ', login.lastname), projectuser.title
FROM projectuser
INNER JOIN login ON projectuser.uid = login.uid
LEFT JOIN project ON projectuser.pid = project.pid
WHERE login.username LIKE @email