MySQL Error 1054: Unknown Column

MySQL Error 1054 (42S22, ER_BAD_FIELD_ERROR) means a column reference cannot be resolved in the current query block. The message often identifies where MySQL looked, such as Unknown column 'customer_id' in 'field list' or ... in 'where clause'. Use the clause named in the error to narrow the search. See the MySQL 8.4 server error reference.

Confirm the column exists on the intended table

Check the live table definition rather than an ORM model or an old migration:

SHOW COLUMNS FROM sales.orders;

You can also query MySQL’s column metadata:

SELECT COLUMN_NAME, ORDINAL_POSITION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'sales'
  AND TABLE_NAME = 'orders'
ORDER BY ORDINAL_POSITION;

Replace sales and orders with the schema and table used by the failing query. Correct a misspelled name or point the query at the intended table. Do not add a column until you confirm that the database schema is supposed to contain it.

Check table aliases and derived-table columns

In a join, qualify a shared column with the table alias that supplies it:

SELECT o.customer_id, c.name
FROM sales.orders AS o
JOIN sales.customers AS c ON c.customer_id = o.customer_id;

If you use an alias, check references against the alias declared in FROM or JOIN, not a different name. A derived table or common table expression exposes only the columns selected inside it; a name from an underlying table is not automatically available outside that query block.

For example, customer_email is unavailable from this derived table because it selects only order_id:

SELECT recent_orders.customer_email
FROM (
  SELECT order_id
  FROM sales.orders
) AS recent_orders;

Add the needed column to the inner select if it belongs in the result, or use the correct query scope and alias.

Do not use a SELECT alias in WHERE

A column alias created in the SELECT list can be used in clauses such as ORDER BY, GROUP BY, or HAVING, but not in WHERE. This query therefore reports an unknown column in the WHERE clause:

SELECT quantity * unit_price AS line_total
FROM sales.order_items
WHERE line_total > 100;

Repeat the expression in WHERE, or calculate it in a derived table before filtering. See MySQL’s documentation on problems with column aliases.

For the special case where an ORDER BY on a UNION references a name that is not in the union result, see MySQL Error 1054 in UNION ORDER BY.

For other MySQL SQL errors, browse the MySQL error troubleshooting index.