Why am i seeing "syntax error near unexpected token" in sql?

Example:

SELECT * FROM users WHERE name = "John
This indicates a syntax error, often caused by a missing closing character or another syntax issue.

Solution:

SELECT * FROM users WHERE name = "John";

Beginner's Guide to SQL