SQL3 min read2026-03-01

SQL Unknown Column Error: Unknown column 'xyz' in 'field list'

Fix Unknown column in field list or column does not exist errors in MySQL, PostgreSQL, and ORMs.

Error Code / Stack Trace

ERROR 1054 (42S22): Unknown column 'is_active' in 'field list'

The database query references a column name that does not exist in the specified table schema.

Typo in column name or casing mismatch (PostgreSQL converts unquoted column names to lowercase).
Missing database migration that adds the new column.
Using double quotes instead of single quotes for string literals in MySQL.

Inspect actual table column names directly in the database.

sql

-- In MySQL:
DESCRIBE users;

-- In PostgreSQL:
\d users

In SQL, single quotes denote values; double quotes denote column/table identifiers.

sql

-- BAD (interprets 'active' as a column):
SELECT * FROM users WHERE status = "active";

-- GOOD:
SELECT * FROM users WHERE status = 'active';

•Creating camelCase columns in PostgreSQL without double quotes, which auto-converts them to lowercase.

In Postgres, unquoted names are folded to lowercase. If created as "userId", you must query it as "userId" with double quotes.