Tag: query-execution

All the articles with the tag "query-execution".

• Why MySQL says "Unknown column" for an alias you just defined

  12 Sep, 2026

  You aliased a column in SELECT, used it in WHERE, and got ERROR 1054. ORDER BY accepts the same alias without complaint. Here's the one rule that explains both.