Fix “Syntax Error at or Near” in SQL

The symptom

You run a query and the database rejects it before touching any data, with a message like syntax error at or near "where". Nothing executed. The parser read your statement left to right, reached a word it could not fit into valid SQL, and stopped there.

Why it happens

The quoted word is where the parser gave up, which is usually one step past the real mistake. In the query below the problem is the emptyFROM clause, but the parser only notices when it reacheswhere and finds no table name in front of it.

So read the quoted token, then look at what comes immediately before it. The common causes are a missing table name, a trailing comma beforeFROM, a missing closing parenthesis, a misspelled keyword, and a reserved word used as an unquoted column name.

The fix

Name the table the query reads from. Once FROM products is present the parser has a complete clause and the statement runs.

When the cause is not obvious, cut the query down. Delete clauses from the bottom up, starting with ORDER BY, then WHERE, until it parses. The last clause you removed contains the mistake.

How other engines word it

Learn more

• Lesson 9.1 · Reading error messages
• Lesson 9.2 · Debugging a query step by step
• Reference · SELECT syntax
• Error · Referenced column not found