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

Example:

SELECT unknownColumn FROM users;

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

Solution:

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

SELECT correctColumn FROM users;