Does WHERE trim the columns?

Question

Accepted Answer

SELECT * always returns all columns defined on the table, regardless of which column you filter on in WHERE. The WHERE clause decides which rows appear, not which columns. All three columns - id, username, email - show up in the result.