MySQLMySQL 1054

MySQL 1054: Unknown Column in Field List

MySQL 1054 is thrown when a query references a column name that does not exist in the specified table or is not in scope. MySQL cannot resolve the identifier at query-compilation time.

Example Query

SELECT username, emal FROM users;
-- 'emal' does not exist

Common Causes

  1. 1Typo in the column name
  2. 2Column belongs to a different table and the table alias is missing
  3. 3The column was dropped or renamed in a recent migration

How to Fix It

Run DESCRIBE table_name or SHOW COLUMNS FROM table_name to see the exact column names. Check for typos and ensure the correct table alias is used when joining multiple tables.

Need a reliable database?

Try Supabase — free PostgreSQL with a generous free tier. No credit card required.

Get started free →

Got a query causing this error?

Paste it into SQLbuddy and get an instant plain-English explanation with optimization tips.

Analyze My Query →
← Browse all SQL errors