How to use alias in where where in mysql

Question

Is there any other way to make this request:

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

I tried, but got an error that an unknown column says in mysql

Answer 1

This may be due to lessor instead of lessor_name in where where. So try below:

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

Answer 2

In MySQL, you cannot use an alias near WHERE .

Answer 3

maybe this will work:

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

Answer 4

This will work.

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