Invalid column reference: column does not exist
Quick summary
Your SQL references a column name that is not in the table — the database reports an unknown column error.
Why this happens
The column name is misspelled or uses the wrong case in a case-sensitive database
The column was renamed or dropped in a schema migration but the query was not updated
The column exists in a different table and needs a table prefix or join to access
Minimal example
await db.query('SELECT user_name FROM users');
// Error: column user_name does not exist — it is usernameawait db.query('SELECT username FROM users');
// Or check schema: DESCRIBE users; to find correct column nameCorrecting the column name to match the actual schema resolves the invalid column reference error.
How to diagnose
Check the table schema with DESCRIBE or information_schema to verify the column exists
Review the column name spelling and case sensitivity of the database
Check if the column is in a different table and needs to be accessed through a join
How to fix
Correct the column name spelling or add the table prefix: table.column
Update the query to use the new column name after a schema migration
Add the missing join to bring the column from another table into the query scope
How to prevent
Use a schema validation tool or ORM that catches invalid column references at compile time
Keep queries and schema migrations in sync and run tests after schema changes
Related Resources
Related Lessons
- SQL Basics
Learn about columns.