SELECT * FROM TABLE WHERE 1 = 2 [closed]

Question

The query:

Explain SELECT * FROM TABLE WHERE 1 = 2

Displays the field names of the given table. Can anyone explain this syntax? Thanks in advance.

Answer 1

You're returning no results, because 1 = 2 is false. (There are no records that match that WHERE clause, so you just get the table headings, and no records.)