title: How to use alias in where clause in mysql
body: <p>Are there any other way of doing this query:   </p>
  
  <pre><code>SELECT CONCAT_WS(" ", strLname, strFname, strMname) AS lessor_name 
  FROM tbl_lessor 
  WHERE lessor = '$lessor_name'
  </code></pre>
  
  <p>I tried it but got an error it says unknown column in mysql</p>