Using column alias in WHERE clause of MySQL query produces an error

by

You can only use column aliases in GROUP BY, ORDER BY, or HAVING clauses.

Standard SQL doesn’t allow you to
refer to a column alias in a WHERE
clause. This restriction is imposed
because when the WHERE code is
executed, the column value may not yet
be determined.

Copied from MySQL documentation

As pointed in the comments, using HAVING instead may do the work. Make sure to give a read at this question too: WHERE vs HAVING.

More Related Contents:

  1. Unknown Column In Where Clause
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Can I reuse a calculated field in a SELECT query?
  4. INSERT INTO SELECT statement with more columns which is not in another table
  5. MySQL how to fill missing dates in range?
  6. WHERE vs HAVING
  7. Column calculated from another column?
  8. Error in MySQL when setting default value for DATE or DATETIME
  9. How does MySQL process ORDER BY and LIMIT in a query?
  10. Search for “whole word match” in MySQL
  11. Generating a random & unique 8 character string using MySQL
  12. Check if MySQL table exists without using “select from” syntax?
  13. sql join two table
  14. Cast int to varchar
  15. SQL query of multiple values in one cell
  16. Import SQL file into mysql
  17. MySQL SELECT last few days?
  18. How to skip certain database tables with mysqldump?
  19. “where 1=1” statement [duplicate]
  20. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  21. how to cast the hexadecimal to varchar(datetime)?
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. How to get a list of months between two dates in mysql
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. How to format number with “.” as thousands separator and “,” as decimal separator?
  27. Using DISTINCT and COUNT together in a MySQL Query
  28. How to check if field is null or empty in MySQL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment