如何在MySQL的where子句中使用别名 [英] How to use alias in where clause in mysql

问题描述

还有其他方法可以执行此查询:

Are there any other way of doing this query:

SELECT CONCAT_WS(" ", strLname, strFname, strMname) AS lessor_name 
FROM tbl_lessor 
WHERE lessor = '$lessor_name'

我尝试了它，但是收到一条错误消息，提示mysql中的未知列

I tried it but got an error it says unknown column in mysql

推荐答案

这可能是由于where子句中的lessor而不是lessor_name引起的.因此，请尝试以下方法:

It might be due to lessor instead of lessor_name in where clause. So try with below once :

SELECT CONCAT_WS(" ", strLname, strFname, strMname) AS lessor_name 
FROM tbl_lessor 
having lessor_name= '$lessor_name'

这篇关于如何在MySQL的where子句中使用别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！