Why am i seeing 'unknown column in field list' in sql?


SELECT unknownColumn FROM users;

This error indicates that the column you're trying to select doesn't exist in the specified table.


Ensure that you've spelled the column name correctly and that it exists in the table you're querying.

SELECT correctColumn FROM users;

Beginner's Guide to SQL